Forum Discussion

Sperling's avatar
Sperling
Advocate II
4 years ago

Cumulative measure for tooltip

I'm interested in a cumulative measure that is based on a dynamic period for a tooltip.   I have a table with the last 31 days showing a daily index, and when I plug a cumulative measure into it, i...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Sperling 

 

Use ALL instead of ALLSELECTED.

Cumulative = CALCULATE(SUM(Sales[Revenue]),FILTER(ALL('Date'[Date]),ISONORAFTER('Date'[Date], MAX('Date'[Date]), DESC)))

 

And you can also use below measure for cumulative total. 

Result = 
var _maxDate = MAX('Date'[Date])
return
CALCULATE(SUM(Sales[Revenue]),ALL('Date'[Date]),'Date'[Date]<=_maxDate)

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

  • Sperling's avatar
    Sperling
    Advocate II
    4 years ago

    Thanks for the reply!

    I don't know if I'm missing something, but when I use my dataset with older sales values as well, I get a cumulative measure up to the current max date.

    I'm interested in a cumulative measure for the days in my date filter for the page.

    • v-jingzhang's avatar
      v-jingzhang
      Community Support
      4 years ago

      Hi Sperling 

       

      Do you put Date table's Date column on X axis of the column chart and into your date filter? How do you set your date filter? Is it possible to provide a sample pbix here (after removing sensitive data)? 

       

      Regards,
      Jing

      • Sperling's avatar
        Sperling
        Advocate II
        4 years ago

        v-jingzhang 
        Hi again,

         

        I've identified the issue in your pbix file too. It happens when I add a slicer based on date and adjust that.

         

        When I add a slicer to your file and move the first date a bit forward, the cumulative tooltip still shows the cumulative value as if the slicer date filter was ignored.