How to count mismatch of two columns in two tables?

[bwang2]

I have one colum in a table for emplyee names (data base), and another table contains the same employes names (manual entry). I want to check if there was any mismatch between them. 

I was thinking using measure = Countrows(Filter(Table1,Table1[colum1]<>Table2[column2].

but Filter function only works in a single table. What should my approch be? Thanks  

[v-yangliu-msft · Accepted solution]

Hi  @bwang2 ,

I created some data:

Table1:

Table2:

Here are the steps you can follow：

1. Create measure.

Measure =
IF(
    MAX('Table1'[column1])=
LOOKUPVALUE(
    'Table2'[column2],'Table2'[employes names],MAX('Table1'[employes names])),"match","mismatch")

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[philouduv]

Hello @bwang2 ,
An other approach could be to create a calculate column where you know the values are correct(Tablereference).

MisMatch = If(CALCULATE(COUNTROWS(Tabletocheck),FILTER(Tabletocheck,

Tablereference[name] == Tabletocheck[name])) > 0, "Match", "Not match")

[tamerj1]

Hi @bwang2 

please try

=
COUNTROWS ( EXCEPT ( VALUES ( Table1[colum1] ), VALUES ( Table2[column2] ) ) )

[bwang2]

Thanks! is there a function I can use to display the mismatch as well?