RANKX

Hi，

Please refer the following formula.

rank1 = 
var _tab=SUMMARIZE('Table','Table'[total scare])
Return
RANKX(_tab,[total scare],,DESC,Dense)

final = 
var _count1=CALCULATE(DISTINCTCOUNT('Table'[name id]),FILTER('Table','Table'[rank1]<EARLIER('Table'[rank1])))
var _count2=CALCULATE(DISTINCTCOUNT('Table'[rank1]),FILTER('Table','Table'[rank1]<EARLIER('Table'[rank1])))
Return
'Table'[rank1]+_count1-_count2 

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

Best Regards

Community Support Team _ Polly