Excluding an item based on an association when other associations may exist

[vistacruise]

I have two simple tables:

Item	Name
1	A
2	A
3	A
1	B
2	B
1	C
2	D

Item	Order
1	10
2	20
3	30

I want to create a visual that shows the items that are NOT associated at all with a Name.  For example, if I choose to exclude name B, I want to see Item 3, Order 30 and nothing else.  I'm not sure what this kind of filter is called, so I'm having trouble searching for help on the topic.  If I try selecting all names except name B, I still get all of the items and order since they are also associated with the other names.

[v-zhangti]

Hi, @vistacruise 

You can try the following methods.

Measure = IF(SELECTEDVALUE(Table2[Item]) in VALUES(Table1[Item]),0,1)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[vistacruise]

Hi, @v-zhangti 

This does appear to "sorta" work, but it is having some bizarre effects on other columns in the Item/Order table that I wish to display.  For example, I have a field that is calculated in the load script with a resultant number. It is showing as blank in each row of the table now.  This makes no sense to me whatsoever.