Match / unmatch count

[Sachy123]

So I have two tables from different sources joined by ID's (Emp_ID) 

EmployeeRatingTable1                

Emp_ID     Employee_Ratings

EmployeeRatingTable2        

Emp_ID     Employee_Ratings     

How do I make a measure/column which I can use to compare the count of employees included in table 1 but nt in table 2

count of matching ratings

count of unmatched ratings

Any help would be great

[amitchandak · Accepted solution]

@Sachy123 , One option, is merge them in Power Query  and have in one table and compare column

Other option

Try if these measures can work

Countx(filter(Table1, Table1[Emp Rating] =related( Table2[Emp Rating]) ), Table1[Emp ID])

Countx(filter(Table1, Table1[Emp Rating] <> related( Table2[Emp Rating]) ), Table1[Emp ID])