Forum Discussion

JayPow28's avatar
JayPow28
Icon for Resolver I rankResolver I
5 years ago
Solved

Average of Column Values

Hi,   I have a Weekly Percent column in a matrix visual that I have calculated using the following formula: Weekly Percent = Var BillHrs = SUM(timeentries[Billable Hours]) Var WorkHrs = MAX('E...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    JayPow28 , You need to make sure hours sum up over week

     

    Var WorkHrs = sumx(values(Table[Week]),calculate(MAX('Employee Working Hours'[Working Hours])))

     

    or

     

    Var WorkHrs = sumx(summarize(Table, Table[employee],Table[Week],"_1",calculate(MAX('Employee Working Hours'[Working Hours]))),[_1])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

JayPow28 , You need to make sure hours sum up over week

 

Var WorkHrs = sumx(values(Table[Week]),calculate(MAX('Employee Working Hours'[Working Hours])))

 

or

 

Var WorkHrs = sumx(summarize(Table, Table[employee],Table[Week],"_1",calculate(MAX('Employee Working Hours'[Working Hours]))),[_1])