Filtering by BOTH Criteria not Either

[Anonymous]

Hello, I have some zip codes with sales data. I have it on some tables and a map. If I filter by clicking on Albert and Mary in Table 1, my map and Table 2 gives me the zip code that has sales for EITHER  Albert OR Mary. I want the zip codes that have sales for BOTH Albert AND Mary. Any suggestions on how can I do this? If I have to use a method different from these tables it would work too. Thanks in advance.

(I am familiar with SQL but I am fairly new in PowerBI.)

Table 1

Sales Agent	Sales
Albert	19
Jeremy	13
Mary	20

Table 2

Zip  Code	Sales
1111	12
2222	10
3333	9
4444	21

Sample Data:

Zip Code	Sales Agent	Sales
1111	Albert	5
1111	Jeremy	1
1111	Mary	6
2222	Jeremy	10
3333	Mary	7
3333	Jeremy	2
4444	Albert	14
4444	Mary	7

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may take a look at the following posts.

• https://community.powerbi.com/t5/Desktop/Null-values-in-matrix-visual/m-p/342583#M153503
• https://community.powerbi.com/t5/Desktop/Fiiltering-table-visualisations-I-need-quot-AND-quot/m-p/602714#M286833