Slicer with overlapping values

Hi 047 ,

If your sample cannot make relationship, you can try this method.

1.Create a table with all categories, donn't make relationship between the two tables.

2. Create a measure.

Check =
IF (
    NOT ( ISFILTERED ( 'Table (2)'[Category] ) ),
    1,
    IF (
        ISFILTERED ( 'Table (2)'[Category] )
            && (
                MAX ( 'Table'[Category] ) = SELECTEDVALUE ( 'Table (2)'[Category] )
                    || MAX ( 'Table'[Category] ) = "Both"
            ),
        1
    )
)

3.Put the new category table in the slicer, and put the measure in the ItemName visual filter, select the value is 1.

Get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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