undefinedcomparison specific products based on customer

[Anonymous]

In the data I have, there is a customer-specific or common material list, but in the data, sometimes a material can be private for 2 customers at the same time. I want to display the special materials that these 2 customers are separated from each other. How can I create this list in power bi? 

[tamerj1]

Hi @Anonymous 
Little confused so I'm trying to guess what exactly is required. This is sample file with the proposed solution https://www.dropbox.com/t/pEFYY7i8d2xZ2cBQ hope it satisfies your requirement.

Customers = 
CONCATENATEX (
    VALUES ( Data[customer] ),
    Data[customer],
    UNICHAR ( 10 ),
    Data[customer],
    ASC
)

[Anonymous]

component	customer	special or custom situation
1234	abc	custom
1234	abc	custom
1234	abc	custom
1234	bcd	custom
1234	bcd	custom
1235	bcd	custom
1235	bcd	custom
1235	xyz	custom
1235	xyz	custom
1235	xyz	custom
1236	abc	custom
1236	abc	custom
1236	xyz	custom
1236	xyz	custom

hi @tamerj1 

in here i want to see different component between 2 customer in dinamic way. ex. abc versus bcd output= 1236(which is disctict component of customer abc vs bcd)  not only one component by the way. in original data, there are tons of components.

[tamerj1]

Hi @Anonymous 

please provide a sample dummy data to work with and advise if you want that in power query or dax?