Forum Discussion
Top N displaying more than N when duplicate values exist
Hi All,
Have an issue with Top N filter in PowerBI visual, when there is a duplicate ranked value. shows more than 5 results.
There a large amount of solutions around this forum and the web, but non seem to fit my use case after trialling them due to ranking 1-5.
RankX works, until there is a duplicate - even setting Dense or Skip for the tiebreaker does not work.
Tried various methods and fields, even creating a separate table, all with varying degrees of success.
Visual Appearance (Bottom 5)
Filter Settings
Data is populated by a likert survey ("Rank 1-5 how well you can use each item") and TopN filter shows bottom 5.
No additional data exists to modify the value as they are all submitted at the same time on the survey (No date hack method available)
Table Data Sample
| Skill | Average of Rating Value |
| 3D Scanner - Einscan Pro+ | 2.5 |
| Dynamic Microphone - Rode | 2.5 |
| Gimbal - Zhiyun Crane3 | 2.5 |
| Mixer - Rode Procaster | 2.5 |
| PTX Camera System | 2.5 |
| Resolume | 2.5 |
| Video mic - Rode GO | 2.5 |
| Volumetric Display - Looking Glass | 2.5 |
| RTI Panels | 2.25 |
| Volumetric Display - Voxon VX1 | 2.25 |
| Chroma Key Kit | 2 |
| Elgato Stream Deck | 2 |
Anonymous Right, that' because of how RANKX and TOPN handle duplicates. You can add a small random number RAND()/100 to break ties. You'd have to create a measure to rank by like:
Measure = AVERAGE([Rating Value])*RAND()/100
2 Replies
Anonymous Right, that' because of how RANKX and TOPN handle duplicates. You can add a small random number RAND()/100 to break ties. You'd have to create a measure to rank by like:
Measure = AVERAGE([Rating Value])*RAND()/100
Anonymous , In your Rank, adds a small random variable using Rand
Rank = Rankx(<code>) +rank()/1000 and then use this in Top N filter
