So I have two tables from different sources joined by ID's (Emp_ID)
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
Go to Solution.
@Sachy123 , One option, is merge them in Power Query and have in one table and compare column
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])
View solution in original post
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!