Forum Discussion
Measure divided by dimension
Hi, I am trying to calculate a Monthly Utilistaion figure which is a cross between dimensions grouped and a _TotalHours measure. I have the following dimensions highlighted in blue My measur...
VendettaBob
You can try this measure:
Monthly Utilization =
DIVIDE(
[_TotalHours],
MAX(Agreement.ContractedHours)
)________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂