And slicing on Matrix

[jpurcell]

I'm having trouble figuring out how to get two slicers to use "and" filtering on a matrix.

All of the data is in one table, with employee name, a category, and a number value. Looks sort of like this:

I want to be able to filter for employees who have only 3s (or 3s and 2s) in all of the categories selected in the other slicer. But it is listing employees with a 3 in any category along with blanks. The dashboard looks like this currently:

But we were hoping to get somehting like this:

 Any Ideas would be appreciated, thanks.

[v-sihou-msft · Accepted solution]

@jpurcell

In this scenario, you can create a measure to determine if Cats related to current Name is equal to selected Cats.

Measure = 
IF (
    CALCULATE ( DISTINCTCOUNT ( Table1[Cat] ), ALLSELECTED ( Table1[Cat] ) )
        = CALCULATE (
            DISTINCTCOUNT ( Table1[Cat] ),
            ALL ( Table1[Name] ),
            ALLSELECTED ( Table1[Cat] )
        ),
    1,
    0
)

Then add above measure into Visual Level Filter.

Regards,

[jpurcell]

Thanks, that worked like a charm.