Cumulative %

Hi harirao ,

We create a sample based on your screenshot and we can use the measure to meet your requirement.

We need to create an index column in Power Query Editor.

Then create a measure like this,

Cumulative % = 
var _total = CALCULATE(SUM('Table'[Diff]),ALLSELECTED('Table'))
var _cumulative = CALCULATE(SUM('Table'[Diff]),FILTER(ALLSELECTED('Table'),'Table'[Index]<=MAX('Table'[Index])))
return
DIVIDE(_cumulative,_total)

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

Best regards,

Community Support Team _ zhenbw

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

BTW, pbix as attached.

Hi harirao ,

You can use the RANKX function to create the Index Value.

Create a Calculated Column