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...
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
Greg_Deckler
Community Champion
Community ChampionAnonymous 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