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.
Hello,
I have a data set that references the employees in two columns. But I need to compare them. When I conduct a count formula, to distinguish the number of cases assigned by an employee and the number of cases scheduled by an employee, the numbers are always identical. Here is what the data looks like. How do count how many ID's have been scheduled by an employee and how many ID's have been assigned by an employee?
Solved! Go to Solution.
HI @Marquian,
You can try to use the following measure formula to calculate the field aggregated based on current employee group:
#Assigned by =
CALCULATE (
COUNT ( 'Interpreter usage report'[Assigned by.1] ),
ALLSELECTED ( 'Interpreter usage report' ),
VALUES ( 'Interpreter usage report'[Employee] )
)
#Scheduledby =
CALCULATE (
COUNT ( 'Interpreter usage report'[Scheduled by.1] ),
ALLSELECTED ( 'Interpreter usage report' ),
VALUES ( 'Interpreter usage report'[Employee] )
)
Regards,
Xiaoxin Sheng
HI @Marquian,
You can try to use the following measure formula to calculate the field aggregated based on current employee group:
#Assigned by =
CALCULATE (
COUNT ( 'Interpreter usage report'[Assigned by.1] ),
ALLSELECTED ( 'Interpreter usage report' ),
VALUES ( 'Interpreter usage report'[Employee] )
)
#Scheduledby =
CALCULATE (
COUNT ( 'Interpreter usage report'[Scheduled by.1] ),
ALLSELECTED ( 'Interpreter usage report' ),
VALUES ( 'Interpreter usage report'[Employee] )
)
Regards,
Xiaoxin Sheng
Sorry for the delay, but that did not resolve my issue. The numbers are inaccurate.
Here is what the table looks like when I try to put the measures in the same visual...
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 |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |