Problem to get cumulative values

[K-LED]

Hi all,

I'm trying to display cumulative values using "Line and stacked column chart" graph. The x axis represents the month number and the y axis represents values. for all valus, I've 2 status displayed below with red and blue colors: 

Below you'll find the measure I've created:

Total Cumulable = 
CALCULATE(
	CALCULATE(SUM(Table[Price net])),
	FILTER(
		ALLSELECTED('Table'[Month Nr]),
		ISONORAFTER('Table'[Month Nr], MIN('Table'[Month Nr]), DESC)
	)
) + 0

The problem is for the month 7, 8 and 11 the red part is not displayed. Even if I don't have values for the status in the red color, I would like to display for months 7, 8 and 11 the values of the precedent month..

Any help to have the correct visuatlisation of cumulative values ? is there any mistake in the measure i'm using ?

Thanks in advance 🙂

[Tanushree_Kapse]

Hi @K-LED ,

Try this measure to get the cummulative total:
Measure= CALCULATE(SUM(Table[Price_net]), FILTER(ALLSELECTED(Table[Month Nr]), Table[Month Nr] <=MAX (Table[Month Nr])))

Mark this as a solution, if I answered your question. Kudos are always appreciated.

Thanks.

[K-LED]

Hi @Tanushree_Kapse thanks for your help but unfortunately it doesn't work..