Slicer (Have product X but not product Y)

[Anonymous]

Hi

I'm trying to figure out how to get an illustration where i can choose a product and then another illustration will show me who does NOT have that product. 

My data is sorted like this: 

Customer	Date	Product	Amount
1	01.01.2019	A	642
1	01.01.2019	B	764
1	01.01.2019	C	608
1	02.01.2019	A	312
1	02.01.2019	B	991
1	02.01.2019	C	448
1	03.01.2019	A	701
1	03.01.2019	B	795
1	03.01.2019	C	377
2	01.01.2019	A	172
2	01.01.2019	B	621
2	01.01.2019	C	278
2	01.01.2019	D	943
2	02.01.2019	A	720
2	02.01.2019	B	447
2	02.01.2019	C	767
2	02.01.2019	D	932
2	03.01.2019	A	212
2	03.01.2019	B	267
2	03.01.2019	C	885
2	03.01.2019	D	331

I have created a slicer where i can pick all my products as shown below (A, B, C, D etc.):

I have also created a meassure that show the customers who have bought this combination of products: 

!Specific Customers that have selected module =

VAR tmpTable1 = GENERATE(VALUES(Customers[Customer]);

EXCEPT(

VALUES(ApiUsage2019[Content.ApiMethodName]);

CALCULATETABLE(VALUES(ApiUsage2019[Content.ApiMethodName]))))

VAR tmpTable2 = SUMMARIZE(tmpTable1;Customers[Customer])

VAR tmpTable3 = EXCEPT(VALUES(Customers[Customer]);tmpTable2)

RETURN CONCATENATEX(tmpTable3;[Customer];"

")

This measure is put into an illustration and it comes out like this (All customer that have the chosen products): 

The thing i need, is to know, if it is possible to create a slicer where i can pick products that the customer "does not have". 

So that i can show customers that have a certain product combination but does not have the selected product(s) from the slicer "does not have" 

e.g. if i pick product A, B and C from my current slicer and product D from "does not have" customer 1 would show up, because in the data they have bought A, B and C but not D.

[v-xicai]

Hi @Anonymous ,

You may create measure like DAX below.

Except slicer =CONCATENATEX (EXCEPT ( ALL ( Table1[Product] ), ALLSELECTED ( Table1[Product] ) ),Table1[Product],", ")

Result:

Best Regards,

Amy

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

[Anonymous]

Hi v-xicai 

Thanks for the reply, but it was not quite what is was looking for. 

The thing you gave me shows what products have not been chosen from the slicer. It does not show what customers that does not have those products. 

I don't know if it is possible but i kinda need two slicers. 

One where i choose specific products that it want to know which companies have and another slicer where i select products which companies does not have. 

So a third table will show me companies that have the selected products from slicer 1 but not the selected products from slicer 2.  

[Anonymous]

Above i have attached a phote of a matrix illustration. Customers are in the first collums and then two selected products are in the second and third collum. 

I would like a visual that shows me the customer "Profil Art" if i selected "Have: getcookiehistory" and sellect "Does not have getcookierecommendations"

Right now this is the best solution but i have to manually look thorugh hundres of customers and write them down seperately for all that have product X but not Y. 

Furthermore i would like to be able to compare more than 2 products, which is difficuelt with the previous mentioned method.