Forum Discussion

JorgeGuajardoH's avatar
JorgeGuajardoH
New Member
4 years ago
Solved

Cumulative Sum Measure Not Working Properly

Hello,   I'm fairly new using power BI, and I need to create a table with a cumulative sum of cases left open for each day/week/month/year   I created masures from my table to substract created  ...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    This is caused by current row content. A month corresponds to multiple dates, which is the cause of the issue.

    Try to create a year month column as a condition to create a measure.

    Measure = CALCULATE(SUM('Table'[Backlog]),FILTER(ALLSELECTED('Table'),'Table'[sort_month]<=MAX('Table'[sort_month])))

     

amitchandak's avatar
amitchandak
Super User
4 years ago

JorgeGuajardoH , Your number are not matching with what you shared in screenshot.

 

but try like

 

Backlog - Acumm - =
calculate([Created cases] - [BL Closed],
filter(ALLSELECTED('2021 (2)'),
'2021 (2)'[Created Short Date] <= MAX('2021 (2)'[Created Short Date])))

 

 

Month should be coming from table 2021 (2)  and should be month of Created Short Date

JorgeGuajardoH's avatar
JorgeGuajardoH
New Member
4 years ago

Thank you Amitchandak,

 

You're rigth, numbers did not match on the table above, I followed your advice and it got closer, however it is still not returning the expected value.

 

Please see below, expected value is as on the table in the left, measure is returning the value of the screenshot in the rigth.

 

 

Any advice on how to solve this will be very much appreciated.

 

Thank you!