Forum Discussion

jpurcell's avatar
jpurcell
Advocate I
9 years ago
Solved

And slicing on Matrix

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 ...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

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's avatar
jpurcell
Advocate I
9 years ago

Thanks, that worked like a charm.