Multi Selected Filter showing more values that it should

Hi, Anonymous 

According to your description, you want to make the table only shows “Breeze” when you select both location types, you can try my steps:

1. Create a measure in Table 2:

Measure =

var _1=CALCULATE(MAX([Company Name]),FILTER(all('Table 2'),[Location Type]="Office"))

return

IF("Office" in SELECTCOLUMNS('Table 2',"1",[Location Type])&&

COUNTX(ALLSELECTED('Table 2'),[Location Type])>2,

IF(MAX('Table 1'[Company Name ])=_1,1,0)

,1)

2. Apply this filter for the table visual:

And you can get what you want, like this:

You can download my test pbix file here

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.