Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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:   ...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    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])))

Tahreem24's avatar
Tahreem24
Super User
4 years ago

Anonymous Try this DAX measure:

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