Top N displaying more than N when duplicate values exist

[carlG]

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

[amitchandak]

@carlG , In your Rank, adds a small random variable using Rand

Rank =  Rankx(<code>) +rank()/1000  and then use this in Top N filter

[Greg_Deckler · Accepted solution]

@carlG 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