Show not sold items

[azaterol]

Hey all,

in the image below I have a example for you of my problem.

I have two tables, the first is the cusomer Table(A,B,C). 

The second is the sold items Table. That was easy!

The last table I want is the items which a customer didint sell. 

As you can see in the left table, customer A buy Coca Cola, Sprite, and so on... . These items should not shown in the right table("Not sold items"). Only these items which the customer did not buy, like Fanta, Water, Apple, etc. should be shown on the Power BI table.

I need a Measure, I tried everything but I didint figure it out how it can be done.

Hope you understand and can help.

Thank you all!

[v-jayw-msft · Accepted solution]

Hi @azaterol ,

Create a measure like below:

Measure =
VAR tmp =
    CALCULATETABLE ( VALUES ( 'sold items'[sold items] ) )
RETURN
    IF ( SELECTEDVALUE ( 'not sold items'[not sold items] ) IN tmp, 0, 1 )

 Then add this measure to visual filter and set value = 1.

Best Regards,

Jay

[amitchandak]

@azaterol , You need to have separate item dimension, post that try this 

Assume you have sales measure 

if(isblank([sales]),1,blank())

Plot this with the item from a separate item dimension