Elements of DAX 06-05: Reviser Puzzle

Easy to read, impossible to remember: "The first argument of CALCULATE() will get evaluated only after the other arguments get evaluated to produce the new Filter Context." This concept is absolutely essential to being able to look at DAX code and understand its behavior, yet it is so counter intuitive that it often takes months and months to properly internalize.

In this video Brian Grant will place the conundrum front and center, so that the problem is obvious and impossible to miss. Then he will walk you through WHY the counter intuitive behavior exists in such a way that will render it much easier to call back up when looking at code.

------------
Don't forget to subscribe to our channel for the latest Power BI, Power Platform, Azure, and Data Analytics content.

At CSG Pro, we love learning and sharing new technologies, processes, and solutions to help you be victorious in your role.

Work with us:

Visit our blog:

[pdadey]

PowerBI has another, less talked about, context. I call it the Brian Context :-).
The way you contextualize the inner workings of PowerBI really helps one understand fundamental PowerBI concepts. Thank you for the series.

[joanneosborne]

Great explanation. Thanks, Brian. I love the concept. 😊

[MilhouseBS]

The diagram at 5:30 makes CALCULATE process very clear. Thanks again for all your work.

[seanmen]

Hi Brian, at around 4:40, you are talking about the temp table generated from argument 2. Should the Values(Mini[Dish]) inside the Filter function get evaluated by the existing filter context as well? Understand in this example you do not have any existing filter contexts but just trying to confirm if my understanding is correct. Thanks!