I have a situation where I have a sales budget at a branch level but not a business segment level. I created a matrix with the hierarchy of branch then business segment. I want to display the budget when the matrix is at it’s highest level (branch) but hide the budget column when a user drills to the next level in the hierarchy (business segment). This is complicated by the fact that we have a business segment slicer. I want to display the budget when there is no business segment selected in the slicer but hide the budget when a user selects a business segment.
What DAX expression would I use to enable this behavior?