How to display the same cumulative value on one month?

[JustinDoh1]

Hello,

I am trying to display same cumulative value of one month by selecting one month from a filter.

I have attached my Pbix file.

As illustrated, currently, cumulative value of March 2022 is 35 M.

But, when I select only one month from the Date Range slicer, I get different amount (11.4 M):

I think I might have to fix the measure for CumSales, and I need your help.

CumSales =
      CALCULATE(
                       SUM(Revenue[Amount]),
                               filter(allselected('Calendar'),
                               'Calendar'[Date] <=max('Calendar'[Date])

                             )

                        )

Thanks.

[Whitewater100 · Accepted solution]

Hi:

This should work! I jsut tested. Using ALL is good when dates are involved.

CumSales 2 = CALCULATE(SUM(Revenue[Amount]),filter(all('Calendar'),'Calendar'[Date] <=max('Calendar'[Date])))

[Whitewater100]

I also makred your Calendar as Date Table.