Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Solved! Go to 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])
@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])
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!