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 th...
  • 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

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