Vlookup without a calculated column

[b2wise]

I have a header table and a fact table linked on 'Item' but I know there are orphaned items in the fact table that do not exist in the header table.

In excel I would do a vlookup to find the missing items.  In PBI I do not like to use calculated columns unless I really need them.

How do I do this in a table visual WITHOUT using a calculated column?

[b2wise · Accepted solution]

Nevermind, the regular lookupvalue formula works in a table visual. I was getting an error due to a different issue.