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 dis...
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..