Headcount of how many staff have project assignments that is less than 85% of their Available Supply

[deevo]

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)

[Jihwan_Kim · Accepted 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 )
)

[deevo]

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!!