Forum Discussion

Multiverse_76's avatar
Multiverse_76
Frequent Visitor
6 years ago
Solved

Help with RANKX

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's avatar
    az38
    6 years ago

    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

1 Reply

  • az38's avatar
    az38
    Community Champion
    6 years ago

    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