Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Problem to get cumulative values

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 🙂

2 Replies

  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    Hi Anonymous ,

     

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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