Help creating slice of non-matching records

[Neal_MF_Harper]

I have a Merch table and a table of Merch Locations, I am trying to create a slice showing a list of Merch from the locations table that do not exist in the Merch table.

Essentially, I am allowing scans of any merch item to the locations table, even if it does not exist in the Merch table. Now I need a list of those location merch items that don’t exist in the main merch table so I can follow up on adding those items to the merch table.

SOMETHING LIKE THIS SLICE FORMULA ON “Locations” table?

IF(([Merch ID]=“Merch”[Merch ID]), False, True)

This seems to return all items, I thought it would return non-matching…