RANKX Problem

Question

I have been using the following formula with RANKX successfully with various tables, but I'm running into an issues where different values get the same rank with the following report:&nbsp;G - Rank =VAR temp = SUM ( RANKX_Problem[G] )RETURN&nbsp; &nbsp;IF (&nbsp; &nbsp; &nbsp; &nbsp;temp = 0;&nbsp; &nbsp; &nbsp; &nbsp;BLANK ();&nbsp; &nbsp; &nbsp; &nbsp;RANKX (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALLSELECTED ( RANKX_Problem );&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SUM ( RANKX_Problem[G] )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; );&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dense&nbsp; &nbsp; &nbsp; &nbsp;)&nbsp; &nbsp;)&nbsp;&nbsp;Notice 201706 has value G=62 and gets RANK 1 correctly, but so does 201702 with G=44&nbsp;Any help appreciated!&nbsp;Thanks,&nbsp;MT

kentyler · Answer

You have 11 different&nbsp; values, but the measure only returns ranks of 1 to 3. What is your intention ?

mturcotte_epq · Answer

I'm sorry, I thought my intention was obvious...

I would like "G - Rank" to contain the ranks from 1 to 11 based on the values of G.

So G=62 would have G-Rank=1

G=44 would have G-Rank=2

G=37 would have G-Rank=3

...

Thanks, MT

v-eachen-msft · Answer

Hi&nbsp;mturcotte_epq&nbsp;,
&nbsp;
I created a similar file as yours but I don't have these issues. You could get slicer by creating an independent table. Could you share your files?
&nbsp;

mturcotte_epq · Answer

Ok I managed to post the file on my One Drive:

https://1drv.ms/u/s!ArclD4PLnaKAnxHB4m7EAzuthu6e?e=QWP7ft

Please let me know what I might have overlooked that could explain this unintended behavior for RANKX.

Thanks, MT

mturcotte_epq · Answer

Actually, please disregard the link posted in my last message as it appears to be a corrupted version of the report I created to illustrate the problem.

Instead, please use this link below to a ZIP file containing the report:

https://1drv.ms/u/s!ArclD4PLnaKAnxKraQDXUakCrlEb?e=7fa5lx

I created a few columns that also exhibit the unintended behavior of RANKX for non-zero values in columns.

Once again, any help appreciated.

Thanks, MT

Forum Discussion

RANKX Problem

5 Replies

Related content

RankX problems

Problem with RANKX

RankX

Logic problem?

Slider problems