Help with RANKX

[Multiverse_76]

Hi

I'm trying to give a rank to every row which is > 0. Something like this:

I'm new to DAX and am really struggling. I think I need a measure, RANKX and FILTER but I just can;t bring them together to get the right result. Any help would be greatly appreciated.

[az38 · Accepted solution]

Hi @Multiverse_76 

try this measure

Rank = 
var _r = RANKX(FILTER(ALL(Table1);Table1[Score]>0);calculate(SUM(Table1[Score]));;ASC)
return 
IF(SELECTEDVALUE(Table1[Score]) > 0;_r;BLANK())

do not hesitate to give a kudo to useful posts and mark solutions as solution