DAX cumulative total efficiency

[dicken]

This is just a question regarding efficiency, is there any difference between

RTC:=SUMX( FILTER(ALL('Calendar'[Date]), 'Calendar'[Date] <= MAX('Calendar'[Date]) ), [TotalUnits])

and

RTC2:=CALCULATE( [TotalUnits], FILTER(ALL('Calendar'[Date]),'Calendar'[Date] <= MAX( 'Calendar'[Date]) ) )

Richard ,

 

[JEC]

SUMX is an iterator which could be a bit less efficient. Is this working too?

RTC2:=CALCULATE( [TotalUnits], ALL('Calendar'[Date]),'Calendar'[Date] <= MAX( 'Calendar'[Date]) )

 

[dicken]

SUMX is an iterator which could be a bit less efficient. Is this working too?

RTC2:=CALCULATE( [TotalUnits], ALL('Calendar'[Date]),'Calendar'[Date] <= MAX( 'Calendar'[Date]) )

 

[dicken]

Yes, But as the measure [Total] = SUMX( Table , Table [Values] ) , doesn't

=CALCULATE( [TotalUnits], FILTER(ALL('Calendar'[Date]),'Calendar'[Date] <= MAX( 'Calendar'[Date]) ) )

also iterate, as far as I know there is not way of doing a cumulative total in DAX with out, in power query you can
use List Generate or list accumulate.

Richard.