Forum Discussion

rolf1994's avatar
rolf1994
Helper II
9 years ago

Cumulative total with date filter

Hello,

 

I'm having a problem creating a cumulative measure when using a date filter in my reports.

 

I am using the following formula: calculate(sum('table'[amount]);filter(all(date[date]);date[date]<=max(date[date])))

 

In my report i have a data filter in which i selected the option to only show data from 1-3-2016 - 30-11-2016.

 

my tables have data from before 1-3-2016, i do not want it to show this data but with my current formula it is showing all data, not only from 1-3-2016 - 30-11-2016.

 

How to fix this?

 

 

Need Help

1 Reply

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi rolf1994,

     

    Please try to change the measure like below:

     

    CumulativeTotal = calculate(sum('Table'[Amount]),filter(all('Table'[Date]),'Table'[Date]<=max('Table'[Date])))

     

    And select the slicer, click the Edit Interactions to check if the funnel is checked. Please download the attached .pbix file and test in your scenario. If issue persists, please share the sample data and desired results for our analysis. If possible, please share the .pbix file.

     

    Best Regards,
    Qiuyun Yu