Cumulative sum

[Jay2639]

Hello experts:

I have calculated Cumulative sum using DAX
Everything is working fine but if for particular year if we have blank then graph is not showing cumulative sum it’s just showing blank only.

For example:
for Year 2022 sales is blank and for 2021 year sales is 10k
And for 2023 yeat sales is 20k

So ideally graph should show 2021 total sales 10K
2022 total sales 10k
And 2023 total sales 30 k

But it’s showing 10k, zero and 20 k respectively

Any idea?

@Greza @FerFrezza 

[Anonymous · Accepted solution]

@Jay2639  This works with the data you shared:

Cumulative Sales =
CALCULATE (
SUM ( Sales[Sales] ),
FILTER ( ALL ( Sales[Year] ), Sales[Year] <= MAX ( Sales[Year] ) )
)