Calculate cumulative backlog with Measure

[Jo5hua22]

Hi Users

I have a use case similar to https://community.powerbi.com/t5/Desktop/Calculate-a-cumulative-year-to-year/m-p/501393

But I would like to perform this use case in a Measure variable. Can you please help me out? I am facing an issue wherein if I drill down, the cumulative data per month is not available. Only in the year view, I can see the cumulative data but not in the month view.

The owner of the previous use case is not active so, if someone has any idea please help me out?

[Jo5hua22 · Accepted solution]

I solved it by myself

You need to add a if condition on the date

Example:

If(selectedvalue(date[date])),

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))

[amitchandak]

@Jo5hua22 , for year wise cumulative use

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))

foroverall

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))

or

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all(date),date[date] <=max(date[Date])))

[Jo5hua22]

Hi

It is not working. I am getting some random values when I do it. Expectation is when i drill down to month view, then it should show the cumulative backlog per month- sort of like this post

https://community.powerbi.com/t5/Desktop/help-with-drill-through-with-cumulative-total/m-p/740267

But the solution in this post is also not working for me