Resource Capacity Report FTE (Full Time Equivalent) Measure

Hi walker8888,

Thank you for reaching out to Microsoft Fabric Community.

To calculate FTE (Full-Time Equivalent) based on a work week over 40 hours, we can create a measure that compares the total hours worked against the full-time equivalent hours (40 hours per week) and translates that into FTEs.

Here's the DAX to build this measure

FTE =  
VAR Total_Hours_Worked = SUM('EmployeeData'[HoursWorked])  
VAR Employees_Count = DISTINCTCOUNT('EmployeeData'[EmployeeID]) 
VAR FTEs = Total_Hours_Worked / (Employees_Count * 40)
RETURN FTEs

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa