Keep cumulative sum when filtering

[Greger1337]

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:

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:

How can I keep the sum from changing when I change the time filter?

[Anonymous · Accepted solution]

Try adding another filter, ALL() to your CALCULATE().

CALCULATE([Omsättning],ALL('BFO Transactions','BFO Transactions'[Date]),DATESINPERIOD…)  

[Greger1337]

Thank you!

Ackumu rullande 12 månader omsättning = 
CALCULATE([Omsättning]; ALL('BFO Transactions'[Date]);
DATESINPERIOD('Date'[Date]; 
LASTDATE('BFO Transactions'[Date]);-12;MONTH)
)

This did exacly what I was after.