By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Download files here https://www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-rankx-function/

This video explains the concept of context transition in DAX. You'll learn about the differences between row context and filter context and how to invoke context transition to create a filter context from a row context. You'll see several functions whose arguments are evaluated in a row context and understand the importance of invoking context transition to make your measures return the correct results. You'll also see how to perform multiple context transitions in more complex measures.

Chapters
00:00 Topic list
00:32 A Recap of Row Context
02:40 A Recap of Filter Context
04:56 Invoking Context Transition
09:40 Context Transition in a Measure
13:17 Finding Help
15:46 Considering Filter Context
20:16 Context Transition and Ranks
23:09 Concatenating a List
27:15 Counting Rows
29:53 Sorting Results
31:44 Multiple Context Transitions

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!