Forum Discussion
Slicer filtering another Slicer
Hi, good morning. I have a very simple model consting of 3 tables : Area, SubArea and Machines. Each Machine belongs to a SubArea and each SubArea belongs to an Area. I trying to creat a repo...
PaulDBrown
Community Champion
Community ChampionAnonymous
If the model
is set up with seperate dimension tables for Area and Subarea, you should be able to achieve what you need using a simple measure:
Filter slicer = COUNTROWS(RELATEDTABLE(Machines)) and add this measure to each slicer in the filter pane and set the parameter =1