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
amitchandak
Super User
Super UserAnonymous , In your Rank, adds a small random variable using Rand
Rank = Rankx(<code>) +rank()/1000 and then use this in Top N filter