Forum Discussion
Helper IIISwitch, True & ISINSCOPE
Super Userandybamber , Create two measure var like this and use them
CALCULATE([Headcount Budget],Table[cc_domain] = "non-domain")
CALCULATE([Headcount Budget],Table[cc_domain] <> "non-domain")
Also, refer :https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Helper IIIHi There amitchandak , thanks for this... i'm not entirely sure that would be the solution, wouldn't this just include or exclude the actual non-domain numbers rather than not display them.... maybe these images might help describe what I am looking for: The first image shows data at the the Domain level (there are 9 domain names, and one of those domain names is 'non-domain') and you can see the headcount budget line, as expected
Domain Level
When you drill down from 'Non-Domain' (which is a domain) to the next level (L3) we can also see the headcount budget line, which for Non-Domain L3 is what I require
Non-Domain - L3
The issue is that when i drill down on say the Business Support domain to L3 I also see the headcount budget line, this isnt what I want to see, i only want to see the headcount budget line for L3 for non-domain as above
Domain L3
I hope that clarifies!
Cheers
Andy