Row Context for Explicit Filter Arguments in CALCU...

ryan25r9 · ‎08-30-2022

In the DAX Guide's definition of CALCULATE, the first step in the evaluation order states as such:

CALCULATE evaluates all the explicit filter arguments in the original evaluation context, each one independently from the others. This includes both the original row contexts (if any) and the original filter context. Once this evaluation is finished, CALCULATE starts building the new filter context.

I'm trying to understand or find an example on when an explicit filter argument would use the Original Row Context. Since Context Transition hasn't occurred yet in the evaluation order, I don't get how Row Context would come into play at all for the explicit filter arguments.

Hoping someone can help clarify or provide a resource that does.

Thanks!

hemanth4pbi · ‎12-23-2022

Check the following article. In the article, measure YOY-3 is using row context in filter argument of CALCULATE.

https://www.sqlbi.com/articles/context-transition-and-filters-in-calculate/

if you find this useful, please mark it

ryan25r9 · ‎08-31-2022

Thanks. I went through all of these links and unfortunately didn't find any instances of Row Context being used in an explicit Calculate argument though.