Forum Discussion

greenguy2012's avatar
greenguy2012
Advocate I
5 years ago

Cumulative Sum Performance

Hi everyone! I’m a bit new to Dax but have a lot of BI/ SQL experience and I’m stuck on a problem.   My goal is to get a cumulative sum of an existing measure, which takes the net of sum(sales) an...
amitchandak's avatar
amitchandak
Super User
5 years ago

greenguy2012 , I am assuming your formula is

 

Cumulative Net =
CALCULATE (
[MeasureNet],
filter( allselected(Calendar),
Calendar[Date] <= max (Calendar[Date])
))

 

or

 

Cumulative Net =
CALCULATE (
[MeasureNet],
filter( all(Calendar),
Calendar[Date] <= max (Calendar[Date])
))

 

that us way to do this.

 

What is the data volume you have

  • greenguy2012's avatar
    greenguy2012
    Advocate I
    5 years ago

    Hi Amit,

     

    Both my original #2 and your allselected version produce the same result on my end. Adding the allselected doesnt change anything.

     

    I'm only dealing with a few thousand records pulling from SQL Server