Ranking and filtering top 10 with multiple rows in Power BI Matrix

[Anonymous]

Dear BI community,

In the below Power BI Matrix (filters applied: fiscal year is 2020-21 and supplier is supplierX), I have 2 rows being firstly Area of Law (12 of these), and Matter Name(hundreds of these). In the values I have client name, matter start date, and total invoiced amount. What I am trying to do is filter out to the top ten matters by total amount invoiced under each area of law (highlighted in sky blue). I thought I could achieve this by creating a rankx measure but it is not working as I expected. How can I proceed so that each area of law section has only the top ten matters invoiced within each area of law? I also do not have access to the advanced filter where I can filter by N on the values.

Please let me know, thank you for your help.

[amitchandak · Accepted solution]

@Anonymous , Assumed Total Amount Invoiced is a measure. Try a measure like and filter for <=10

Rankx(filter(summarize(allselected(Table), Table[Area of Law], Table[Client Name]), [Area of Law] = max([Area of Law]) ), [Total Amount Invoiced],,desc, dense)

or refer

https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

[Anonymous]

Thank you very much Amit. I referred to your link and was able to make the code to solve this issue perfectly. Sincerely appreciated.