Show Top 10 rows in a filtered table

[nsaray]

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!

[CNENFRNL · Accepted solution]

RANK =
RANKX(
    ALLSELECTED( yourtable[MARG ID] ),
    CALCULATE( SUM( yourtable[Exposure Gap] ) )
)

Put the measure into the visual filter

[nsaray]

Hi

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

[fhill]

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

[nsaray]

yep tried that 😞

[nsaray]

ok figured out what the problem was. there were multiple Marg IDs in the dataset and so it was returning every row associated with that Marg ID instead of only the top Exposure Gaps