Forum Discussion
Anonymous
7 years agoNot applicable
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 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 |
Anonymous ,
You may take a look at the following posts.
1 Reply
- v-chuncz-msft
Community Support
Anonymous ,
You may take a look at the following posts.