Compare two tables and display missing rows from the first table in a dynamic fashion

Anonymous 

Create a measure to check if the records exist in Table 2

ExistInTable2 =  CONTAINS('TABLE - 2','TABLE - 2'[Name],MAX('TABLE - 1'[Name])) * 1

Add the above measure to the Visual Filter of Table 1 and set to  = 0 and click apply. It will update automatically 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Anonymous 

One way is to create a measure to use in the filter pane:

Names Exclusive To table 1 = 
VAR Tab1 = VALUES(Table1[Name])
VAR TAb2 = VALUES(Table2[Name])
RETURN
COUNTROWS(EXCEPT(Tab1, TAb2))

Add this measure to "Filters for this visual"  in the filter pane and set the value to 1