Using slicer to filter out value from categorical visualizations

Hi jtooke ,

Thanks for reaching out to the Microsoft fabric community forum.

Try these measures

1. Get Metadata of the Selected Use Case
Create these measures:

a. Selected Lifecycle 
Selected Lifecycle =
CALCULATE (
SELECTEDVALUE('YourTableName'[Lifecycle]),
FILTER('YourTableName', 'YourTableName'[Use Case Name] = SELECTEDVALUE(UseCaseSlicer[Use Case Name]))
)

b. Selected Country
Selected Country =
CALCULATE (
SELECTEDVALUE('YourTableName'[Country]),
FILTER('YourTableName', 'YourTableName'[Use Case Name] = SELECTEDVALUE(UseCaseSlicer[Use Case Name]))
)

2. Create Filtering Logic Measure

a. For Lifecycle Visual:
Show Similar Lifecycle Excluding Selected =
VAR SelectedUC = SELECTEDVALUE(UseCaseSlicer[Use Case Name])
VAR SelectedLC = [Selected Lifecycle]
RETURN
IF (
'YourTableName'[Use Case Name] <> SelectedUC &&
'YourTableName'[Lifecycle] = SelectedLC &&
NOT(ISBLANK('YourTableName'[Rating])),
1,
0
)

b. For Country Visual:
Show Similar Country Excluding Selected =
VAR SelectedUC = SELECTEDVALUE(UseCaseSlicer[Use Case Name])
VAR SelectedCountry = [Selected Country]
RETURN
IF (
'YourTableName'[Use Case Name] <> SelectedUC &&
'YourTableName'[Country] = SelectedCountry &&
NOT(ISBLANK('YourTableName'[Rating])),
1,
0
)

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best Regards,
Sreeteja.
Community Support Team