How to make exclusion table in Power BI

[gvg]

I am looking for a solution of this probably simple problem. I have two tables in Power BI: Inventory and Sales:

Inventory                          Sales      

Item   Title                        Item    Quantity

123    Soap                       124     5

124    Detergent               123     8

125    Toothpaste

126    Tooth brush

How can I make a Table visual that lists items not sold. I.e. I need to return:

Item   Title

125    Toothpaste

126    Tooth brush

[VP · Accepted solution]

Mearge or link both table and apply filter in visual (Quantity = Blank)

[VP]

You can mearge in Query editor or Link in data model. Both options will give you same result

[gvg]

OK, thanks. How do I link tables in Power BI? You mean establish relationship between the two tables?