Solved: Re: Exclude a subset: Need to find out locations w...

saurabh_kedia_ · ‎11-06-2019

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 · ‎11-06-2019

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:

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

v-diye-msft · ‎11-06-2019

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:

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.