cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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 this:2017-07-18 12_16_53-Baseball cards v0.13 - Power BI Desktop.png

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:2017-07-18 12_21_17-Baseball cards v0.13 - Power BI Desktop.png

But we were hoping to get somehting like this:

 

2017-07-18 12_22_16-Baseball cards v0.13 - Power BI Desktop.png

 

 

 Any Ideas would be appreciated, thanks.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: And slicing on Matrix

@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.

 

 

8.PNG

 

Regards,

View solution in original post

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: And slicing on Matrix

@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.

 

 

8.PNG

 

Regards,

View solution in original post

Highlighted
Regular Visitor

Re: And slicing on Matrix

Thanks, that worked like a charm.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors