Forum Discussion

pathomson's avatar
pathomson
Regular Visitor
8 years ago
Solved

RANKX Formula is missing a ranking number

I have several Rankings based off a single table of categories that is linked to other data tables. Some of my results show the ranking from 1 to 46, but others show 1 to 47 with a ranking number ski...
  • pathomson's avatar
    pathomson
    8 years ago

    Thanks,

     

    I have found the issue and the resolution throught trial and error.

    I had 5 different tables that I am ranking, and when they are joined, there are stations that are not in the master list of stations I want to rank by. To solve this issue, instead of the ALL function, I have changed it to ALLNONBLANKROW function.

    Now I am receiving the correct value of 46 as the highest instead of 47.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Anonymous

 

I am having the issue that you have describe using the Skip option I wish for my data to be displayed in the Dense option solution.

 

Can you provide more context around how to use the Dense option please as I am usure as to what you mean but it is what I need.

 

Thanks,

Ricky

pathomson's avatar
pathomson
Regular Visitor
8 years ago

At the end of your formula (the last option) you have the option to use skip or dense. the skip will pass all ties and show the next number in the ranking. the dense will use the next number.

So if you have a ranking of 5 values and number 2 and 3 are tied scores, it will go 1,2,2,4,5. If you use dense it will go 1,2,2,3,4.

There is some help on the microsoft page below whjich may explain it better than I can:

 

https://msdn.microsoft.com/en-us/query-bi/dax/rankx-function-dax

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    That worked perfectly. Thanks!!