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 a table that has employee hours by employee ID and Project. In the table the employee id will show up on multiple rows if they work on more than one project. I have a Dax to count the number of employees.
Full/Part Time | Total Headcount |
A | 5 |
B | 9 |
C | 8 |
Example of 'Employee' table
User ID | Project | Total Hours |
a1 | aa | 100 |
a1 | bb | 60 |
b1 | aa | 40 |
c1 | bb | 160 |
c1 | cc | 10 |
d1 | aa | 80 |
d1 | cc | 20 |
Thank you
Hi, @Higgs11
I am not sure if I understood your question correctly, but please check the below picture and the sample pbix file's link down below.
All measures are in the sample pbix file.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you for responding. I have three DAX Measures, one for Total Headcount, one for Total Hours, and one for capacity/budget hours. The main Employee table is large with Employee ID in multiple rows. I cannot count rows, I cannot "SUMMARIZETABE". I want to know how many employees are within 0-50%. 51%-75%, 76%-100%+ of the capacity/budgeted hours. Three DAX measures.
I like the Group table, played around with it yesturday. Can I build a group table to compare Total Hours againg Capacity/Budgeted hours? Like 15 Employees worked 25% of the capacity/budgeted time?
Thanks again
Hi, @Higgs11
Thank you for your feedback.
Sorry that I quite do not understand your question.
What do you mean by, I cannot count rows, I cannot "SUMMARIZETABE" ?
Please share your sample pbix file's link, then I can try to look into it.
Thanks.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |