Power BI unique Rank

[Anonymous]

Hi Folks,

So Iam working with power BI with the below data but my Rank measurement is not giving me accurante ranking. Total Callout is a measurement as well just a sum of the collumn "Callout". Would like to hear some from you guys.

[v-stephen-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,
Stephen Tao

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

It is suggested to add an Index column in the Power Query as follows.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

If entries in the Total callout column are the same, then why should they not be given a rank of 1?  If you do not agree with me on this, then why why should seating capacity get a rank of 3? (why not 1?)

[Greg_Deckler]

@Anonymous - Hmm, this issue of rank uniqueness has come up before. I have some articles that deal with aspects of this including:

• To *Bleep* with RANKX! - Microsoft Power BI Community
• The Mythical DAX Index (powerbi.com)

[Anonymous]

Hi, already checked them but the "VALUE" indicated which is the "TotalCallout" is a measure not a column. Which makes it a difficult to formulate.