How to use slicer with conditions

[shikhavidyarthi]

I have a slicer with few items in it like A,B,C,D_Total,D, E,F,G. I have multi-selection option. However, I want to add a condition here. Whenever I select D and D_Total together, D should be disabled automatically and only D_Total should reflect the rest data in tab.

[Anonymous · Accepted solution]

Hi @shikhavidyarthi ,

I suggest you to create an unrelated Dimitems table for slicer.

Measure:

Filter = 
VAR _VALUES =
    VALUES ( DimItems[Items] )
VAR _VALUESINCONDITION1 =
    FILTER ( _VALUES, [Items] <> "D" )
RETURN
    IF (
        ISFILTERED ( DimItems[Items] ),
        IF (
            AND ( "D" IN _VALUES, "D_Total" IN _VALUES ),
            IF ( MAX ( 'Table'[Items] ) IN _VALUES && MAX ( 'Table'[Items] ) <> "D", 1, 0 ),
            IF ( MAX ( 'Table'[Items] ) IN _VALUES, 1, 0 )
        ),
        1)

Add this measure into visual level filter and set it to show items when value = 1.

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.