topic Help with RANKX in DAX Commands and Tips

Help with RANKX

Multiverse_76 — Thu, 09 Jan 2020 09:33:11 GMT

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.

Re: Help with RANKX

az38 — Thu, 09 Jan 2020 10:54:11 GMT

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