The Order of Execution in DAX Code

[somnath6309]

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

[Dhairya]

Yeah you are going on right path.