Top/Flop N for each hierarchy while drilldown

[moritzmassimo]

Hi,

I have following issue that seems quite obvious, but I can't manage to solve it, nore find that exact problem here:

I have a hierarchy with two levels:

1. Category (Vegetables, Meat, Milk etc.)
2. Subcategory (Carrot, pork, Apple etc.)

Those categories should be displayed via a bar chart, compared by their sales increase to last year with a drill down to the next hierarchy level. Her comes the challenge now, I want to show within each hierarchy level the top 5 (sub)categories. When using the top n filter, both hierarchy levels are filtered, which is not requested. E.g. when filtering for top 5 Categories and then drilling down to sub categories I just get the sub categories of the top 5 categories.

Does anybody has an idea on how to accomplish that?

Thanks!

[v-jayw-msft]

Hi @moritzmassimo ,

Please share some sample data so that we could create a pbix and test dax formula.

Best Regards,

Jay

[amitchandak]

@moritzmassimo , Use isinscope to switch the top measure when you drill down

refer if needed

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/