Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I am trying to do a headcount of the workforce who are assigned work that equates to less than 85% of their available time.
Many thanks in advance!
For example:
Staff Name | Supply hours | Assignment hours | Assignment % (Assign hours/ Supply) |
Alice | 8 | 8 | 100% |
Bob | 8 | 6 | 75% |
Colin | 8 | 4 | 50% |
Expected results:
I would expect that I have a headcount of 2 people (Bob and Colin), because their Assignment% is less than 85%.
What I tried:
Headcount for Assign <0.85 = CALCULATE(COUNT([Staff Name]), [Assignment%] < 0.85)
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
It is for creating a measure.
Headcount expected measure: =
COUNTROWS (
FILTER ( Data, DIVIDE ( Data[Assignment hours], Data[Supply hours] ) < 0.85 )
)
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.
Hi,
Please check the below picture and the attached pbix file.
It is for creating a measure.
Headcount expected measure: =
COUNTROWS (
FILTER ( Data, DIVIDE ( Data[Assignment hours], Data[Supply hours] ) < 0.85 )
)
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 so much, I was on the right path but I have much to learn and understand about how this works. I appreciate your help!!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
37 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
32 | |
28 | |
24 | |
24 |