Forum Discussion
Cumulative total tooltip
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?
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])))
3 Replies
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])))
amitchandak thank you, I created a variable for MAX date and was trying to use that but it wasnt working properly, this was perfect
Anonymous Try this DAX measure:
Cumulative Sum = CALCULATE(SUM(Table2[Downloads]),FILTER(ALL(Table2),Table2[Date]<=MAX(Table2[Date])))
