Top 10 and filter

Hi Sylvine_Wyz ,

You get more than 10 values with Top 10 filter because of common values and hence power bi by default dense ranks it.

You will need to create a rank column and pull this rank column in top 10 filter.

1. Create a new column with below dax; This column will set bifercation between same values :

Number+Random = 'Table'[number]+RAND()

 

2. Create another column for ranking and this will be pulled in top 10 filter:

RANX =

RANKX(

'Table',

'Table'[Number+Random]

,

,1

)

 

Note:

Names in my above example,

> Table Name = Table

> Field to filter top 10 = Number

> Column 1 created = Number+Random

> Column 2 created = RANX

 

Reference Image:

 

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!