Forum Discussion
rel2022
4 years agoFrequent Visitor
Slicer Hierarchy Help
Hi, I'm new to PowerBI and trying to figure out how to solve a problem related to adding multiple filters to a slicer and the hierarchy it creates. My data is made up of survey questions, the av...
amitchandak
4 years agoSuper User
rel2022 , You should use isinscope in your calculations
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
rel2022
4 years agoFrequent Visitor
amitchandak Thanks for the response. I'm new to all this, would you mind elaborating on how I'd use isinscope to help with this problem? My visuals mostly use measures to calculcate the average of either all of the questions or specific sub-sets of them. Thanks!