Cumulative Sum function

[Maz_0102]

Hello fellow friends

I want to do a cumulative on stages column and do a chart similar in the screenshot below

can someone please show how I can do this on a dax

I would really appreciate please

[Anonymous · Accepted solution]

Hi @Maz_0102 ,

Please try code as below to create a measure.

Cumulative Count = 
CALCULATE(COUNT('Table'[Site]),FILTER(ALL('Table'),'Table'[Stages]<=MAX('Table'[Stages])))

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Create a forth column in the table, CountValue, and it has the # (1,2,3) from the Stage column - Stage 1 = 1, Stage 2 = 2, Stage 3 = 3. Then, create a DAX measure to SUM the new column rather than a count.

Stage Cummulative = SUM('TableName'[CountValue])