I would like to create a measure that reports production rate, based on two pieces of information. The first piece of information is a sum of the hours spent in a status of “Working”. The second piece of information is a sum of units of work resolved (in my case this is an existing measure called “Initial Miles resolved”)
The general math would be Production Rate = (sum of hours in working) / (sum of Initial Miles resolved). Pretty straightforward, I’m just not sure of the proper syntax.