Cascading Slicer

[pfarahani]

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

[Anonymous · Accepted solution]

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.

[pfarahani]

I 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 filter

[amitchandak]

@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