Forum Discussion

Sachy123's avatar
Sachy123
Helper V
4 years ago
Solved

Match / unmatch count

So I have two tables from different sources joined by ID's (Emp_ID)    EmployeeRatingTable1                 Emp_ID     Employee_Ratings     EmployeeRatingTable2         Emp_ID     Employee_Rat...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    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])

amitchandak's avatar
amitchandak
Super User
4 years ago

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])