Proportion of staff are over-utilised (submitting more than their capacity) vs under-utilised

[Yrstruly2021]

Please assist. I am trying to answer the question below. I have made some calculations. Please advise if it is correct.

What proportion of staff are over-utilised (submitting more than their capacity) vs under-utilised (not
using their full capacity)?

https://drive.google.com/file/d/1w_-i4JvdcYApxtI3QD3MUOE52NYYvcxx/view?usp=sharing 

Under-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')

[Anonymous]

Hi @Yrstruly2021 ,

Looking at the DAX code you provided, I did not notice any syntax errors. I am also unable to open the link you provided. Can you provide some specific data (without privacy information) and what you expect to get at the end. The combination with actual data will allow me to better understand and solve the problem you are having.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Yrstruly2021]

Here is the PBIX: https://drive.google.com/file/d/1w_-i4JvdcYApxtI3QD3MUOE52NYYvcxx/view?usp=sharing