Problems with hiding data unless single selection in slicer. Data is shown upon multiple selections

Hi RDKleinJan ,

I download your sample, as the two tables have relationship, when you select mutiple values in the slicer, the List2 visual will always be filtered be the slicer, so it can't be blank.

Here's my solution.

1.Create a new table by the following formula.

Table = VALUES('Organization sales'[Organization])

Get this table, it should has no relationship with other tables.

2.Create a measure.

Aggregate values = 
IF (
    ISFILTERED ( 'Organizations'[Organization] )
        && CALCULATE (
            DISTINCTCOUNT ( 'Organizations'[Organization] ),
            ALLSELECTED ( 'Organizations'[Organization] )
        ) = 1,
    MAXX (
        FILTER (
            ALLSELECTED ( 'Organization sales' ),
            'Organization sales'[Organization] = MAX ( 'Table'[Organization] )
        ),
        'Organization sales'[Values]
    ),
    BLANK ()
)

3.Put the Organization column which is in the new table and the measure into table visual, get the expected result.

I attach the 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.