Get Top 5 Records in Power BI Table View Including Grouped Values

[Ramees_123]

I am using my below table visual. I need to get the top 5 records based on current exposure amount field.

The top 5 condition should be including the group fileds Group name, updated orr and industry of risk fileds.

Please help.

[v-janeyg-msft]

Hi, @Ramees_123 

According to your description, I think you can create a calculated column and use it in filter pane. It needs to use rank nesting multiple times to avoid repeated rankings.

Like this:

Column = 
RANKX (
    ALL ( 'Table' ),
    RANKX ( ALL ( 'Table' ), [Current Exposure] ) * 100
        + RANKX ( ALL ( 'Table' ), [Industry] ) 
        + RANKX ( ALL ( 'Table' ), [ORR] ) 
        + RANKX ( ALL ( 'Table' ), [Group Name] ),,ASC
)

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

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

[CTozzi]

May this could help you: https://community.powerbi.com/t5/Translated-Spanish-Desktop/Los-5-mejores-registros/m-p/1457584#M135...

[Ramees_123]

No. This doesn't help. @CTozzi 

[CTozzi]

Could you share a sample of your data?

[Ramees_123]

@CTozzi  Please find the below data. I need the top 5 Current exposure to be in my table visual.

[CTozzi]

@Ramees_123 if I understood what you want, you can filter the top 5 by current exposure as the image below. Let me know if that is it.

[Ramees_123]

@CTozzi  No. In your example, you have found Top 5 current exposure supporting Group value alone.

But I am asking how to combine Group, ORR and Industry too.

Note: In your sample, if single group has multiple ORR or Industry, then you will end up with more than 5 rows here.

[CTozzi]

@Ramees_123 what exactly would you like to see in the columns ORR and Industry?

[Ramees_123]

@CTozzi  In your sample data keep additional entry for Group 5 with other ORR and Industry.

Example :- Group 5 -- ORR 7 -- Industry 6 -- 100400

After addition, see what happens. It will show you 6 records instead of 5. That is my problem.

[CTozzi]

@Ramees_123 what if you change the visualization to a Matrix? Then you can choose to collapse each group line. 

[Ramees_123]

@CTozzi  No. Not looking for matrix visuals.