Cumulative Sum Measure Not Working Properly

[JorgeGuajardoH]

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  from closed but when I use the recommended dax measure for cumulative sum, it is not providing the expected values, 

The expected result is:

Month	Backlog Accum
Jan	971
Feb	13521
Mar	32427
Apr	57218
May	88228
Jun	129586
Jul	178116
Aug	232791
Sep	287954

The measure I'm using is: 

Backlog - Acumm - =

calculate('2021 (2)'[Backlog Month],

filter(ALLSELECTED('2021 (2)'),

'2021 (2)'[Created Short Date] <= MAX('2021 (2)'[Created Short Date])))

I've been following a lot of post related to this topic but I can figure it out how to get it to work as expected, any guidance/help is very much appreciated.

[V-lianl-msft · Accepted solution]

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]

@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]

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!