Forum Discussion

mturcotte_epq's avatar
mturcotte_epq
Advocate I
6 years ago

RANKX Problem

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:   G - Rank = ...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi mturcotte_epq ,

 

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?

 

  • mturcotte_epq's avatar
    mturcotte_epq
    Advocate I
    6 years ago

    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