Forum Discussion

byWing's avatar
byWing
Icon for Helper I rankHelper I
3 years ago

Help!~ Average hours per person by task

Hi all,

 

I am still new to PowerBI so DAX is overwhelming to me. I am not sure do i start with calculate or average first... =(

 

I am trying to calculate the average hours per person spent on the task "Operation" for each place. 

 

Objective is to plot a bar chart of:

y-axis: average hours per person on task "Operation"

x-axis: Place

 

Below is my sample data:


Your help is much appreciated.

 

Thank you very much!

 

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    byWing , Try a measure like

    averageX(Values(Table[Person]) , calculate(Sum(Table[Hour/month]), filter(Table, Table[Task] = "Opeartions")))

    • byWing's avatar
      byWing
      Icon for Helper I rankHelper I
      3 years ago

      Hi amitchandak 

      Thank you for your reply.

      I tried your suggestion but I am not sure what is wrong:

       

      Would appreciate your advice pls. Thank you for your help~

  • byWing's avatar
    byWing
    Icon for Helper I rankHelper I
    3 years ago

    hi All,

     

    I am still struggling with this. Would anyone be able to help please?

     

    Thank you so much~

  • BrianConnelly's avatar
    BrianConnelly
    Icon for Resolver III rankResolver III
    3 years ago

    Try the following which calculates the average hours per person, broken into variables for easy to read the steps..

     

     

    Average Hours Per Person =
VAR filteredOperations = FILTER(Table, Task = "Operations)
VAR averageHoursPerPerson = SUMMARIZE(filteredOperations,Table[Person],"Avg.Hours",AVERAGE(Table[Hour]))
VAR averageHours = AverageX(averageHoursPerPerson, [Avg.Hours])

RETURN averageHours