Forum Discussion
Computing Resource Utilization Per Day, Week and Month
Wow that fixed it! I changed the relationship to both and changed the %Utilization to use:
%Utilization = DIVIDE([#Hours Spent],SUM('Developer Date Table'[Hours Required]),0)
You're amazing parry2k!
Here's the result that makes more sense. :)
hahaha, same here, Bud. Thanks a lot! You're a great help..:smileyhappy:
polaris3028 not sure what you are showing here, you need to show what aggregation you used in value section when you drop "Hours Required" from this new calculated table? sorry if i'm not clear what I'm asking.
not sure either... but here's the aggregation in the table
No worries, atleast you have solution, mark it answer if you think it is resolved.
check relationship please, make sure it is both direction.
Wow that fixed it! I changed the relationship to both and changed the %Utilization to use:
%Utilization = DIVIDE([#Hours Spent],SUM('Developer Date Table'[Hours Required]),0)
You're amazing parry2k!
Here's the result that makes more sense. :)
YAY, can breathe now. Glad to hear it is fixed. Cheers buddy and good luck :)
hahaha, same here, Bud. Thanks a lot! You're a great help..:smileyhappy: