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:
yes it need to be column, the file you sent me in that #Hours Required 2 is a column and that is why I used that one, seems like you are making chages at your end at the same time :(
Opps, sorry about that. I restored the previous version and did as instructed. After creating the relationship below:
Here's the result of the table. Is there another step to take after this?
It's not correct stil. :(
No worries, atleast you have solution, mark it answer if you think it is resolved.
what aggegation you are using for "Hours Required" it suppose to be SUM
It's SUM... and I tried to add the Hours Required field in the table to check the result....
Is the relationship as shown above correct? What should be the %Utilization after we set a new table?
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.
one more thing check your relationship is both direction, not single.
not sure either... but here's the aggregation in the table
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: