Forum Discussion
Calculate cumulative backlog with Measure
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?
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])))
3 Replies
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])))
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
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])))
