Please assist. I am trying to answer the question below. I have made some calculations. Please advise if its correct.
What proportion of staff are over-utilised (submitting more than their capacity) vs under-utilised (not
using their full capacity)?
Utilization.pbix (281.7 KB)
BlockquoteUnder-Utilized Staff Percentage =
1 - [Over-Utilized Staff Percentage]
Over-Utilized Rate =
CALCULATE(
COUNTROWS(‘Utilization Report’),
‘Utilization Report’[Actual Hours For Week] > ‘Utilization Report’[Weekly Capacity]
) / COUNTROWS(‘Utilization Report’)