Filter NOT in another table in Power BI using DAX

Question

In Power BI, I have two tables and I need to generate a new table that includes only the records from table 1 that not match with any record in table 2

Customer Table

Sales Table

The difference Table should have the records in Table 1 Not in Table 2

ID	Name
3	Malto

How can I get the difference table between two tables in Power BI?

Answer 1

You can simply use the below DAX formula to get rows in Table1 and not have corresponding rows in Table2 using DAX in Power BI

Difference Table = FILTER(Customer,NOT(CONTAINS(Sales,Sales[CustomerID],Customer[ID])))

See also Power BI: RELATED Vs LOOKUPVALUE DAX

Comments

Worked like Charm, Many Thanks!