Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Removing Ranking Duplicates

Hi all,   I have a duplicate ranking issue. At an overall level, it's fine, however bringing in multiple columns creates duplicate rankings.   As you can see overall is fine, but group 1 ha...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, Anonymous 

First, create a Index in PowerQuery.

Then click Apply&Close.
Create a calculated column, and treat the Index you just created as a secondary sort, which must be uniquely identified and cannot have duplicate values. Otherwise, when your sort has the same value and the sub-sort value is the same, the rank will be the same. Here is my preview:

Column = ROWNUMBER(ORDERBY('Table'[Totalvols],DESC,'Table'[Index],ASC))

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

mark_endicott's avatar
mark_endicott
Super User
2 years ago

Anonymous - I dont agree with this solution, though you are correct, it removes the duplicates. In terms of ranking, the duplicates are legitamately there.

 

If a business user was to ask what the criteria was for separating the items that have 100 as a total volume, the answer would be "random chance" and that's not acceptable. It could lead to a poor decision being made by an organisation.