How to add Multiple TopN to a single visual? (Either using a filter or the function)

[rincewind]

Here is the scenario

There are Fruits and Sub fruits being collected from various farms and this needs to be visualized in a table.  Below is a sample of the table.

Fruit	Farm	Value	Sub Fruit Type
Fruit 1	Farm 1	182	Fruit 1 Sub 4
Fruit 1	Farm 2	825	Fruit 1 Sub 3
Fruit 1	Farm 3	520	Fruit 1 Sub 2
Fruit 1	Farm 4	634	Fruit 1 Sub 1
Fruit 2	Farm 1	31	Fruit 2 Sub 4
Fruit 2	Farm 2	311	Fruit 2 Sub 3
Fruit 2	Farm 3	144	Fruit 2 Sub 2
Fruit 2	Farm 4	47	Fruit 2 Sub 1
Fruit 3	Farm 1	870	Fruit 3 Sub 4
Fruit 3	Farm 2	223	Fruit 3 Sub 3
Fruit 3	Farm 3	736	Fruit 3 Sub 2
Fruit 3	Farm 4	598	Fruit 3 Sub 1
Fruit 4	Farm 1	26	Fruit 4 Sub 4
Fruit 4	Farm 2	729	Fruit 4 Sub 3
Fruit 4	Farm 3	197	Fruit 4 Sub 2
Fruit 4	Farm 4	384	Fruit 4 Sub 1
Fruit 5	Farm 1	740	Fruit 5 Sub 4
Fruit 5	Farm 2	475	Fruit 5 Sub 3
Fruit 5	Farm 3	970	Fruit 5 Sub 2
Fruit 5	Farm 4	790	Fruit 5 Sub 1
Fruit 6	Farm 1	808	Fruit 6 Sub 4
Fruit 6	Farm 2	136	Fruit 6 Sub 3
Fruit 6	Farm 3	630	Fruit 6 Sub 2
Fruit 6	Farm 4	343	Fruit 6 Sub 1
Fruit 7	Farm 1	935	Fruit 7 Sub 4
Fruit 7	Farm 2	525	Fruit 7 Sub 3
Fruit 7	Farm 3	497	Fruit 7 Sub 2

Using a matrix, I want to visualize the top 5 fruit types based on values and then the top 2 sub fruit types. I can get the top 5 Fruit types to be visualized by adding a top N filter to the visual but cant add another Top N filter to the top 2 Fruit Sub Type. How do I proceed?

I would link the file for everyone to see but i dont know how to upload a pbix file here

[amitchandak]

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

or

Try category or sub-category rank

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale