With some help from you guys Im getting there now and i require one more piece of your help.

I now have the dates and times my employees come in through the gate at work, and the expected working times they are expected to be productive.

What i want to do now is measure the expected productive hours against what they actually clock in the SAP system and measure their utilization percentages. the target is a minimum of 85% per day and i want to show that for each employee in a bar graph.

Expected Hours & Minutes Inside (Measure) = The expected times the should show SAP clocking’s for. for example if they clock 8 hours on that day its 100% utilized if they clock 6.8 hours that’s 85% which is the minimum expected target per day.

Im struggling to get the measure correct from the COOIS table for the actual clocked durations in SAP. i created a measure called COOIS Clocking but doesn’t appear to pick up correctly in the table

I then want to then calculate the utilization using the expected working time / Actual clocking using the measure Utilization %

Take just the 7th Dec 2020 for Khuloud for example in the table i see she has made 7 clocks on SAP on that day totaling approx 6.5 hours and yet she was suppose to work a 5 hour day according to her shift assignment so she would be around 115% utilized that day which would need investigation.

Yes many thanks for that, i have managed to convert your measure now to a duration

As i said basically i want to calculate the time in the building (gate clocking’s for that day ) against what each person clocks on (COOIS clocking’s) and get the utilization of that person.

I need that in one table and have placed the measures i need in the tab in the attached PBIX however when i add the expected time in building measure i dont see the right thing i assume the context is wrong could you have a look for me and see if you can get the utilization % measure working?

Hi @Krays23, did the response provided by @AntrikshSharma help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!

Hi @Krays23, we’ve noticed that no response has been received from you since the 29th of January. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!