powebi detects as duplicate issue with top N - first values.

[florin]

Hey guys. Can someone help me please with a filter? I'm trying to use a Top N - first 5 values and is not working for me

So basically i wanna see the top 5 NPS And those top 5 basically have the value 10 But powebi detects that as duplicate and takes the other values in cosideration

[ray_ux]

What method did you use first?

[florin]

it's here

 

[ray_ux · Accepted solution]

Ok, there are work arounds for this but the best one is to add a rand()*0.000001 value to your column
Either as a calculated column or just before your topN
https://docs.microsoft.com/en-us/dax/rand-function-dax

or make measure using topN but not just use the column, use column + RAND()*0.00001