Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Show Top 10 rows in a filtered table

Hi

This seems easy to do but all the solutions I have tried to research don't seem to work for me. All I want to do is display the top 10 rows in a table based on Exposure Gap, descending. The number of rows can change from month to month. For each month selected, I want to show the top 10 for that particular month.

 

Thanks for your help!

 

 

Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago
    RANK =
RANKX(
    ALLSELECTED( yourtable[MARG ID] ),
    CALCULATE( SUM( yourtable[Exposure Gap] ) )
)

    Put the measure into the visual filter

5 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Icon for Community Champion rankCommunity Champion
    5 years ago
    RANK =
RANKX(
    ALLSELECTED( yourtable[MARG ID] ),
    CALCULATE( SUM( yourtable[Exposure Gap] ) )
)

    Put the measure into the visual filter

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi

       

      Thanks, I've tried that but it's still displaying lots and lots of rows. Any idea what i'm doing wrong?

       

       

      • fhill's avatar
        fhill
        Icon for Resident Rockstar rankResident Rockstar
        5 years ago

        I'm assuming you've tried the built-in 'Top N' filtering?