To find TOP 50 brands

[Sherli]

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)

[Ashish_Mathur]

Hi,

I am totally confused and have no idea of what youw want.  Show the expected result very clearly.

[Sherli]

Please help me in finding a solution to this question

@amitchandak  @Ashish_Mathur