Help with RankX

[Multiverse]

Hi

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

MyCol	MyRank
-1.85
0.51	3
-1.88
-2.82
0.37	2
0.24	1
-1.66

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.

 

[JustynaMK]

Hi Multiverse,

You should be able to do it with:

Rank = IF([MyCol] > 0, RANKX(Sheet1, [MyCol]), 0)

Here's the result:

 

[Multiverse]

Many thanks; greatly appreciated.

 

[JustynaMK]

You're most welcome & good luck with your report!