topic Re: How to display the same cumulative value on one month? in DAX Commands and Tips

How to display the same cumulative value on one month?

JustinDoh1 — Thu, 03 Mar 2022 19:38:32 GMT

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 — Thu, 03 Mar 2022 20:00:13 GMT

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 — Thu, 03 Mar 2022 20:00:58 GMT

I also makred your Calendar as Date Table.