DAX Cumulative total measure efficiency

[dicken]

Hi,
I've used a running total but it could apply to other things; are there advantages or more importantly disadvantages to the following measures;

RMT_A:=VAR ddate = MAX( Calendar1[Date]) 
RETURN
CALCULATE( [Tunits] , FILTER( ALL( 'Calendar1'[Date]), 'Calendar1'[Date] <= ddate ) )

RTM_B:=VAR ddate = MAX( Calendar1[Date]) 
RETURN
SUMX( FILTER( ALL( 'Calendar1'[Date]), 'Calendar1'[Date] <= ddate) ,[Tunits])

RTM_C:=VAR ddate = MAX( Calendar1[Date]) 
RETURN
SUMX(CALCULATETABLE( VALUES( 'Calendar1'[Date]), 'Calendar1'[Date] <= ddate),[Tunits])

just curious as to if there is much difference?

Richard

 

[Matt Allington]

They are all technically sound. The first is the most common usage. To identify which is the most efficient, you would need to use something like DAX Studio to test the performance. It is possible they are identical, but you would have to check.

Read about “item 4” in this article on my website

DAX Studio for Power BI: Getting Started

DAX Studio is a free tool that allows you to query your Power Pivot/Power BI data models. Learn exactly how using DAX Studio can add value ?

exceleratorbi.com.au

 

[dicken]

Thanks, as you said the first is what I'd go for, I was just curious,

Richard.