Issue with calculating percentages

[ChrisAZ]

So I am trying to get my % column in the graphic to calculate the percentage of WO Hours relative to Paid Hours. What I have noticed is that it is not calculating a 0% value for all of the months in which the employee had no WO Hours. Those should be 0%, and then when looking at it for the full range of dates included for that employee or group, it should be doing it based on total numbers. For example, for 2024, for Brenden Baxter, it is showing WO hours of 16.15, and Paid Hours total to 609.99. It shows 13.26% (which is the value of December and the only month that has WO Hours), but it should really be 2.64% over the indicated time period of 2024.

I know here is also an issue in the sense that it is set to "SUM" but none of the other options provide correct results either. In the second screen shot for Dalton Mattson, you can see how it is adding the percentages from the months that have values instead of providing a true average percentage.

I have also included a copy of the PBIX for reference:
https://drive.google.com/file/d/19mpW2gCHJ01jhO0NuKS38d_5MdP7oIuZ/view?usp=sharing

[parry2k · Accepted solution]

@ChrisAZ you should add % Worked  as a measure instead of column:

%Worked Measure = 
 DIVIDE ( 
    SUM ( 'Shop Labor - Labor Time entries -Fleetio'[Time] ),
    [Paid Hours]
 )

[ChrisAZ]

Thanks so much! This works!