Forum Discussion

aktripathi2506's avatar
aktripathi2506
Icon for Helper IV rankHelper IV
10 years ago
Solved

Calculating average of measures

I have created a measure which calculate the efficiency per week by following formula: 1 - DIVIDE([Hour Spent],[Total available hours])   I have calculated week after week this, now I want the ave...
  • jahida's avatar
    jahida
    10 years ago

    Asumming you don't have that summary table built out and you just want to plug the initial table into a matrix or table visual, here's a measure you can use (might be minor syntax errors, I'm not testing but I'm pretty sure the concept is sound):

     

    AVERAGEX(SUMMARIZE(Table, Table[week], "Sum of Hours", SUM(Table[hours spent]), "Average available", AVERAGE(Table[Available hours for the week])), 1 - DIVIDE([Sum of Hours], [Average available]))

aktripathi2506's avatar
aktripathi2506
Icon for Helper IV rankHelper IV
10 years ago

Hi Vvelarde,

 

Seems good. Can you please advise how did you do that so I can also try the same and then confirm you if it works for me too.

 

Thanks.

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
10 years ago

hi aktripathi2506

 

Measure Efficiency:

 

Efficiency =
AVERAGEX (
    SUMMARIZE (
        'Average-Table';
        'Average-Table'[week];
        "Efficiency"; SUM ( 'Average-Table'[hours spent] )
            / AVERAGE ( 'Average-Table'[Available hours for the week] )
    );
    [Efficiency]
)

 

Measure%Effic:

 

%Effic = 1-[Efficiency]