Cumulative total by months

[Anonymous]

Hi, 

I would like to have cumulative total sum of planned costs and currently I have used this formula: 

Cumulative Planned = CALCULATE( SUM(Query1[Planned cost]); FILTER(ALL(Query1); Query1[Date]<=MAX(Query1[Date])))

.. and it worked until I needed to add another dimension 'reporting month' to the data. The idea of the reporting month is to keep track of changes of planned costs every month compared to previous month's data. So I would use reporting month in a slicer. But in this case the filtering is not correct for Cumulative Planned measure, as I have used ALL function in the formula.

Do you have any suggestions how to fix this?

Thank you in advance, 

Liis

[Zubair_Muhammad · Accepted solution]

@Anonymous

I think you just need to replace ALL with ALLSELECTED

[Anonymous]

And as simple as that it was. Thanks 🙂