Ranx and filter function

^{Hi brendanoshea ,}

 

^{Please follow these steps:}

^{(1)My test data}

 

^{(2) Create a new measure}

NEW SCORE = 
VAR _PLAYER = MAX('Table'[player])
VAR _INDEX = CALCULATE(MAX('Table'[Index]),FILTER(ALL('Table'),'Table'[player] = _PLAYER))
VAR _SCORE = CALCULATE(MAX('Table'[score]),FILTER(ALL('Table'),'Table'[Index] = _INDEX))
RETURN _SCORE


RANKX = 
RANKX(ALL('Table'),[NEW SCORE],,DESC,Dense)

 

^{(3)Final output}

 

 

^{If this is not what you need, please point it out further or provide sample files}

 

^{Best Regards,}

^{Gallen Luo}

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