Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two data table, one with total employee number and one table that shows those who are Sick with two columns one with date and the other one with employee number. Now I want to see how many of the total employee number are sick in procentage?
Solved! Go to Solution.
measure = COUNT(TABLE_NAME_2[Employee_Numner]) / COUNT(TABLE_NAME_1[Employee_Number])
Table_name_2 refers to the ones who are sick
Table_name_1 refers to all employees
measure = COUNT(TABLE_NAME_2[Employee_Numner]) / COUNT(TABLE_NAME_1[Employee_Number])
Table_name_2 refers to the ones who are sick
Table_name_1 refers to all employees
Hi @okletsgo,
Could you please offer me some sample data if possible?
Regards,
Daniel He
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |