Measure to compare values in two different table

gauravnarchal , A measure to me used with table 1 Number

Measure = if(isblank(COUNTX(filter(Table1, Table1[Number] in values(Table2[Number])),Table1[Number])), FALSE(),TRUE())

gauravnarchal Join the both table using relationship. Then create a measure in table 1:

Match = IF(SUM(Table1[Number]) IN {SUM(Table2[Number])}, TRUE(),FALSE())

 

Hey, 
You could write measure like this to get the solution required.

Let me know if this works!

v-yalanwu-msft, Anonymous, Tahreem24, amitchandak 

Not to piggyback, but I have an additional question to the above solutions.

Table 1 is an employee roster. (Employee ID, name, work location)

Table 2 is a list of employees who have been audited (Employee ID, name, date audited)

The measures above show me a True/False if an employee appears on Table 2 (the audit list).  However, I would like to use a slicer to filter by work location.  Currently, my slicer returns the entire list of employees (with the correct True/False result ) instead of only those who are assigned to the sliced/selected work location.

Any ideas?