Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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!!
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
87 | |
59 | |
52 | |
38 | |
21 |