How to Change Measure depend on the level of hierarchy or drill down

[mm14222]

I have a table with 4 Drill down levels, i added in Rows 

Layer1

Layer2

Layer3 (should only be available for channels that has value)

 In Layer3, some has values while others dont, and this is causing to have the measures repeating as per this screenshot.

I would like to be able to detect the Layer3 and if it is for example Affiliates, then it provide 0 for any measure that doesnt have value.

Your kind support is highly appreicated.

[Shahid12523]

 Switching Measures by Hierarchy Level in Power BI? Yes, it’s Possible!

If you’ve built reports in Power BI, you’ve likely seen the matrix visual show the same measure across all levels of a hierarchy. 📊 But what if your users need different insights at different depths?

Let’s say:
👥 At the top level (Department), users want to see Total Headcount
🧑‍🤝‍🧑 But when they drill into Gender, they want to see % Share instead

💡 That’s where scope-aware DAX comes in!
✅ Detect the current level in the hierarchy
✅ Switch the measure based on scope
✅ Apply dynamic formatting — numbers at higher levels, percentages at deeper levels

It’s a game-changer for visuals that tell different stories depending on how far users explore — ideal for:

Workforce headcount with gender mix
Inventory vs turnover
Revenue vs conversion rate

[amitchandak]

@mm14222 , isinscope should able to help

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