topic Row Context for Explicit Filter Arguments in CALCULATE in DAX Commands and Tips

Row Context for Explicit Filter Arguments in CALCULATE

ryan25r9 — Tue, 30 Aug 2022 19:38:11 GMT

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!

Re: Row Context for Explicit Filter Arguments in CALCULATE

amitchandak — Wed, 31 Aug 2022 02:41:04 GMT

ryan25r9 , Check if these blogs can help

https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/

https://www.sqlbi.com/articles/row-context-in-dax/

https://www.statslab-bi.co.nz/project/row-filter-context-dax/

https://blog.enterprisedna.co/dax-power-bi-what-is-row-context/

Re: Row Context for Explicit Filter Arguments in CALCULATE

ryan25r9 — Wed, 31 Aug 2022 15:47:08 GMT

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.

Re: Row Context for Explicit Filter Arguments in CALCULATE

Anonymous — Fri, 23 Dec 2022 08:47:58 GMT

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