Exclude a subset: Need to find out locations where the product has not been campaigned yet

[saurabh_kedia_]

Hi Folks,

I need to find out locations where the product is not campaigned yet.

Please go through the sample problem below:

Products

Car

Bike

Truck

Product Name	Locations
Car	India
Car	US
Car	China
Bike	US
Truck	India
Truck	US

All Locations

India

US

China

Indonesia

Malaysia

For example if a person selects product "car" then "Indonesia" & "Malaysia" should show up as places where the campaigning in not yet done. Product "Truck" should show up "China", "Indonesia" & "Malaysia" as not completed.

Regards,

Saurabh

[v-diye-msft · Accepted solution]

Hi @saurabh_kedia_ 

You can use this measure:

Measure = 
IF(MAX(Table2[All Locations]) in VALUES(Table1[Locations]),0,1)

 Then filter it as 1: