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 numbe...
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

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?  

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        yep tried that 😞