Dueling Current Rows: Shootout at the OKPI Corral

Though usually the result of a mistake rather than an act of DAX genius, it is entirely possible to have not one, but two “Current Rows” active at the same time. Often times people won’t even know they’ve done it till they go to Revise the filters and get results that are utterly baffling to them.

In this video Brian Grant is going to walk you through what happens when Current Row Filtering (Context Transitions) runs not just into two Current Rows, but two Current Rows that disagree with each other. In the process he will give you a more technically sophisticated way to think about The Current Rows (Row Context) in the world of DAX and once again illuminate just how elegant and simple the whole language actually is.

Click here to download the companion files

Share This:
Twitter
Facebook
LinkedIn

Stay up to date with the latest customer data news, expert guidance, and resources.

Iteration and Error Handling in M Query

All iteration roads in M Query eventually lead to the List.Generate function. In strengthening our data manipulation skills through Power Query, we absolutely need this looping function.

More Resources

Trusted By Over 6 Million End Users​

Industry leaders and over 6 million end users choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, SkyPoint Cloud turns siloed customer data into connected customer experiences.