Forum Discussion
Calculate the productivity = target time / real time
Hello everyone 😁 I'm quite a novice in PowerBI so I would like your guidance on my problem please. I have a list of operations with targeted time and recorded real time in production. Those ...
VahidDM
Super User
Super UserHi Valentin
Use DAX to create a measure, try this:
%productivity = sum(Table[Target time (hours)]) / sum(table[Real time recorded (hours)])
and set the measure format to percentage.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!