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.

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!!