To find TOP 50 brands

Hi,

I have a dataset similiar to below one and I want to create a DAX where i can filter TOP N among SubCatAC and also among SubCat BC based on Value1 for each Category (i.e, Top10 for CatA and Top 10 for CatB).

 So basically I need Top N for third level drill down(i.e SubCat AC ) based on Value 1 for each 1st level..(i.e Cat A and Cat B etc)