Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

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.

 

Need Help
Show and Tell

11 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      No. This doesn't help. CTozzi 

      • CTozzi's avatar
        CTozzi
        Resolver I
        5 years ago

        Could you share a sample of your data?

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi, Anonymous 

     

    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.