Forum Discussion

MichalHoltz's avatar
MichalHoltz
Frequent Visitor
9 years ago
Solved

How to do an average of multiple columns?

I have 3 columns and would like to get the average of 3 of them. How do I do that? App1 App2 App3 1 2 1 3 2 1 2 3 5 3 4 5 5 4 3 2 5 4
  • vanessafvg's avatar
    vanessafvg
    9 years ago

    MichalHoltz you right!

     

    what about 

     

    (AVERAGE(Table2[SAP SRM Functionality])+average(Table2[SAP SRM Productivity])+average(Table2[SAP SRM Quality])+average(Table2[SAP SRM Support]))/4?

     

     

tjm4q2's avatar
tjm4q2
Frequent Visitor
4 years ago

You are the only one correct on this thread -- notwithstanding missing values that saturate your counts, taking the average of the summation of averages (otherwise known as the mean of means) IS NOT the same as taking the average of two columns worth of data; there are actually three common ways to take the average when using multiple columns and dang has utilized the most correct way.

tjm4q2's avatar
tjm4q2
Frequent Visitor
4 years ago

Update: An even more correct way using DAX would be to use a summarize(sumx()) statement.

  • pangelidis's avatar
    pangelidis
    Regular Visitor
    2 years ago

    Sumx doesn't work on variable tables