Forum Discussion

polaris3028's avatar
polaris3028
Helper III
8 years ago
Solved

Computing Resource Utilization Per Day, Week and Month

Hi PowerBI Gurus,   I'm stucked and I need help. Trying to compute for utilization rate per resource, been able to figure it out if table shows with per resource, but everytime i remove the resourc...
Need Help
Show and Tell
  • polaris3028's avatar
    polaris3028
    8 years ago

    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. :)

  • polaris3028's avatar
    polaris3028
    8 years ago

    hahaha, same here, Bud.  Thanks a lot! You're a great help..:smileyhappy:

polaris3028's avatar
polaris3028
Helper III
8 years ago

Here's the measure i used for Required Hours,where  #RequiredHours = DISTINCTCOUNT(Table, [Date])*7.5

parry2k's avatar
parry2k
Super User
8 years ago

i think ask here is hours spent % again hours required, correct?

  • parry2k's avatar
    parry2k
    Super User
    8 years ago
    hours spent = SUM(table[hours spent])

hours required = SUM(table[hours required])

% Resource Required = DIVIDE([hours spent], [hours required], 0)

    add above measure and change data format for "% resource required" to "%"

     

     

  • polaris3028's avatar
    polaris3028
    Helper III
    8 years ago

    yes, parry2k.  sort of utilization rate for a resource.