Cumulative total tooltip

[Anonymous]

Hi all, 

I am trying to create a tool tip that will show the running total of downloads & cannot seem to get it right. I am using a line chart to show date and total downloads for each date:

Date          Downloads

1/1/21            50

1/2/21            60

1/3/21            70

1/4/21             80

any suggestions on how to accomplish this?

[Tahreem24]

@Anonymous Try this DAX measure:

Cumulative Sum = CALCULATE(SUM(Table2[Downloads]),FILTER(ALL(Table2),Table2[Date]<=MAX(Table2[Date])))

[amitchandak · Accepted solution]

@Anonymous , Measure

Without date table

Cumm = CALCULATE(SUM(Table[downloads]),filter(allselected(Table),Table[Date] <=max(Table[Date])))

With date table

Cumm = CALCULATE(SUM(Table[downloads]),filter(allselected(date),date[date] <=max(date[Date])))

[Anonymous]

@amitchandak  thank you, I created a variable for MAX date and was trying to use that but it wasnt working properly, this was perfect