topic Sequence of calculations in DAX in DAX Commands and Tips

Sequence of calculations in DAX

scee07 — Thu, 15 Dec 2022 11:15:02 GMT

Hi community,

cannot find the answer to this simple question:

with the textbook example

ListPriceRanking = COUNTROWS ( FILTER ( VALUES ( 'Product'[List Price] ), 'Product'[List Price] > EARLIER ( 'Product'[List Price] ) ) ) + 1

does the engine calculate in the sequence that is suggested: first inner loop with the inner row context. Then calculate whatever is as filter context outside (which is obviously not visible here) . This is presumbably answered already. Please refer me to the link.

Best regards

Christian

Re: Sequence of calculations in DAX

FreemanZ — Thu, 15 Dec 2022 11:34:12 GMT

Hi Christian scee07

What is the question?

Re: Sequence of calculations in DAX

scee07 — Thu, 15 Dec 2022 11:44:13 GMT

The question is: what is the real sequence of calculations in the engine? Always first filter context, then inner row context. The other way round, or some parallelization? Or depending on some criteria?

Re: Sequence of calculations in DAX

FreemanZ — Thu, 15 Dec 2022 12:00:51 GMT

For most functions/expressions, from inside out, from left to right, from top down.

But CALCULATE is very different, it starts with all the argument and keep the first argument evaluated last.

Re: Sequence of calculations in DAX

scee07 — Thu, 15 Dec 2022 12:25:22 GMT

Great, this is exactly what I wanted to know.

Best regards

Christian