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_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

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

1 Reply

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