Forum Discussion
Helper IICascading Slicer
Hello All,
In my model I have a dimension table for Courthouse and a dimension table for Departments.
What I am trying to do is, when the user selects a courthouse or multiple courthouses, then the next slicer which is departments, should only display the departments according to the courthouses that were selected. Thanks
Hi pfarahani ,
You may try this:
Measure = VAR _allSelect = SUMMARIZE ( FILTER ( ALLSELECTED ( 'Courthouse' ), 'Courthouse'[Courthouse] IN ALLSELECTED ( Courthouse[Courthouse] ) ), 'Courthouse'[ID] ) RETURN IF ( MAX ( 'Departments'[ID] ) IN _allSelect, 1, 0 )Then apply it to filter pane set as "is 1", the final output is shown below:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
pfarahani , You need to take a measure from the common fact and check that it is not blank in the visual level filter of the department
explained here https://www.youtube.com/watch?v=cyOquvfhzNM
pfarahaniI am trying to create a measure like this:
Courthouse Filter =FILTER('Department – Slicer', 'Department – Slicer'[Courthouse Substring] = SELECTEDVALUE('JBSIS Probate Courthouse'[CourthouseAbv]))This syntax does not work for now, but Im saying filter down the list of departments based on the selection of the courthouse filterHi pfarahani ,
You may try this:
Measure = VAR _allSelect = SUMMARIZE ( FILTER ( ALLSELECTED ( 'Courthouse' ), 'Courthouse'[Courthouse] IN ALLSELECTED ( Courthouse[Courthouse] ) ), 'Courthouse'[ID] ) RETURN IF ( MAX ( 'Departments'[ID] ) IN _allSelect, 1, 0 )Then apply it to filter pane set as "is 1", the final output is shown below:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
