Keep cumulative sum when filtering

Question

I having trouble with my cumulative sum.I have data from 29 months and I am calculating a rolling sum for the last 12 months like this:Ackumu rullande 12 månader omsättning = 
CALCULATE([Omsättning]; 
          DATESINPERIOD('Date'[Date]; 
                        LASTDATE('BFO Transactions'[Date]);-12;MONTH
                       )
         )The result looks like this:&nbsp;The problem is I only want to show the periods when the rolling sum is a complete year so I filter it but the the cumulative rolling sum no longer starts at the beginning of my data set and the result looks like this:&nbsp;&nbsp;How can I keep the sum from changing when I change the time filter?&nbsp;&nbsp;

anonymous · Accepted Answer

Try adding another filter, ALL() to your CALCULATE().&nbsp;CALCULATE([Omsättning],ALL('BFO Transactions','BFO Transactions'[Date]),DATESINPERIOD…)  &nbsp;

Forum Discussion

Keep cumulative sum when filtering

2 Replies

Related content

Cumulative Total

Creating Cumulative Graphs

Year to date cumulative

Cumulative total more than current value using current filters

Cumulative Total