Sequence of calculations in DAX

[scee07]

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

[scee07]

Great, this is exactly what I wanted to know.

Best regards

Christian

[scee07]

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?

[FreemanZ · Accepted solution]

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. 

[FreemanZ]

Hi Christian @scee07 

What is the question?