calculate / display a cumulative Sum

[Markus_P]

Hello

I am locking for a way to calculate / display a cumulative Sum. See the red line below:

Sadly, I was not able to find a solution. Has anyone an idea on how this would work?

Thanks

[Mani_1]

Hi @Markus_P ,

Create measure 
Cumulative Total = CALCULATE( SUM('Table'[Wert]), FILTER( ALL('Table'), 'Table'[Date] <= MAX('Dimdate'[Date]) ) )
Then add Cumulative Total on Y-axis and date on X-axis.
Thanks

[Markus_P]

This Works, Tanks.

I was wondering if there is a way to do this when my filter are no Values and are not in an Alphabetical Order. Therefore, I wand to use a custom order. I can create a second column that has a ranking information. But I use this then I can’t show the “real” Date in the visual.

[Greg_Deckler]

@Markus_P See this video for a running total: