Forum Discussion

somnath6309's avatar
somnath6309
Icon for Helper I rankHelper I
3 years ago

The Order of Execution in DAX Code

Hi, All,

Pls consider the following code: 

CALCULATE (
CALCULATE (
[Sales Amount],
AND (
'Date'[Date] >= DATE ( 2007, 1, 1),
'Date'[Date] <= DATE ( 2007, 04, 30 )
),
ALL ( 'Date' )
),

'Date'[Year] = 2007,
'Date'[Month] = "April" )

as per my understanding, the order of execution is as follows:

 

01. Outer Calculate applies filter : April, 2007

 

02. ALL('Date") from inner Calculate removes all filters. ( as we have learned that Calculate Modifiers are applied to the Final filter context before explicit filter arguments ).

 

03. Finally, from inner CALCULATE, the Filter arguments within AND are applied i.e. Date range from 01st Jan, 2007 to 30th April, 2007.

Pls let me know whether my understanding is correct or not

1 Reply