Show only top 8 in table

[Roym]

I have a table visual in my report that has the columns 'Name'  and 'Rating'. The column 'Rating' will have values from 1-5. There will be duplicates so you can have multiple 1's, 2's, etc. When I apply the filter 'Top N' on my visual and filter on 'Rating'  I choose 'Average' as that is the best I guess in this case? But when I then say I want to have the 'Top 8' it will show more then 8 when for example you have 4 times a '1', 3 times a '2' and 3 times a '3', it will then show 10 rows. Is there a way it only show 8 values in this case? (I understand why it happens as it can not determine which '3' rows to include/exclude but in my case it doesn't matter which one it takes)

Name	Rating
Name 1	3
Name 2	1
Name 3	2
Name 4	1
Name 5	2
Name 6	3
Name 7	2
Name 8	1
Name 9	1
Name 10	3

[ryan_mayu · Accepted solution]

pls try this

Measure = max('Table'[rating])

Measure 2 = max('Table'[Name])

rank = rankx(all('Table'),[Measure],,ASC)+rankx(all('Table'),[Measure 2],,ASC)/10

rank2 = rankx(all('Table'),[rank],,ASC)

then apply the rank 2 in the table visual

pls see the attachment below

[Roym]

Great, thanks!!!

[ryan_mayu]

you are welcome