Top 5 with cut in 5 Rows

[Pikachu-Power]

Hi all,

When I use the filter Top 5 for a table it can happen that I get 7 or more rows because of equal values. But After 5 Rows I want a cut. Example:

Company  Values

AB              40

CB              35

DE              30

DS              20

FR              10

--------------------------------------

GH             10

ST              10

I tried RANKX to get an Index 1,2,3,4,5 and filter that but seems not to be so easy 😕 

[v-zhenbw-msft · Accepted solution]

Hi @Pikachu-Power ,

We can create an auxiliary column to meet your requirement.

1. Create a column to distinguish the same value.

sort condition = RANKX('Table','Table'[Company],,ASC,Dense) * 0.0001 + 'Table'[Values]

2. Then we can use the column to get the top 5 value. Filter the company’s Top N and put the [sort condition] column in By value.

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Refer: https://forum.enterprisedna.co/t/rank-unique-ranking-when-there-are-duplicate-values/2815/6

Check 6 Jun for tie breaker

Also  these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

[Pikachu-Power]

Thats what I find and tried at first 😕 I have no dates like radacat and no index like enterprisedna. and duplicates values dont work in my case. no other way?

I think that duplicates values dont work in my case because i have have date instead of value and use

Total Value = COUNT( Rank_tbl[Dates] ). for duplicates values i get blank.