Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filtering by BOTH Criteria not Either

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 AgentSales
Albert19
Jeremy13
Mary20

 

Table 2

Zip  CodeSales
111112
222210
33339
444421

 

Sample Data:

 

Zip CodeSales AgentSales
1111Albert5
1111Jeremy1
1111Mary6
2222Jeremy10
3333Mary7
3333Jeremy2
4444Albert14
4444Mary7