The DAX language is essential when building data models in either Power BI or Microsoft Fabric. One of the primary reasons why some DAX expressions have low performance is because it performs (too) many context transitions. But even worse, sometimes context transition (or the lack of context transition) causes unwanted results for your DAX expressions.
Context transitions occur in DAX when you need a filter context while you were in a row context. It can happen explicitly as well as implicitly.
This session dives into these context transitions. After a brief recap on row versus filter context, we will explore the different scenarios in which context transitions occur, and look into the factors that can make this process more expensive to execute.
This session is intended for participants who already have a basic understanding of row and filter context in DAX