Filter/Slicer - And Logic instead of OR

[amtbew]

Here's an example of my data

Location	Category	Sales
A1	Red	1000
A1	Blue	1500
A2	Red	2000
A3	Blue	2000
A4	Red	2500
A4	Blue	2500

I'd like to be able to filter or slice to just the rows that the Red and Blue category both have an entry. 

Here is the desired output

Location	Category	Sales
A1	Red	1000
A1	Blue	1500
A4	Red	2500
A4	Blue	2500

Ultimately I'm trying to compare Red vs Blue.

I'm assuming I need some helper columns to get around the default functionality. If I multi-select both Red and Blue, then I get all the rows returned that either has an entry.

Thanks

[Ashish_Mathur]

Hi,

PBI file attached.

Hope this helps.

[AlexisOlson]

There's a community blog article on this topic:

https://community.fabric.microsoft.com/t5/Community-Blog/Apply-AND-logic-in-the-slicer/ba-p/2881583

[amtbew]

This did work. However, I'm also looking to see the summary of the two categories. 

This was my starting data. 

Location	Category	Sales
A1	Red	1000
A1	Blue	1500
A2	Red	2000
A3	Blue	2000
A4	Red	2500
A4	Blue	2500

Using the blog article method was able to add a slicer and select Red & Blue to display this:

Location	Category	Sales
A1	Red	1000
A1	Blue	1500
A4	Red	2500
A4	Blue	2500

Looking to add a seperate table, that would show the following if both Red & blue were selected

Category	sum of Sales
Red	3500
Blue	4000