Forum Discussion

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

Frequent Visitor

9 years ago

Thanks. I tried this but I get an error message- The AVERAGE function only accepts a column reference as an argument

What am I missing (I'm new to Dex)?

Measure = AVERAGE(SUM(Table2[SAP SRM Functionality])+SUM(Table2[SAP SRM Productivity])+SUM(Table2[SAP SRM Quality])+SUM(Table2[SAP SRM Support]))

Community Champion

9 years ago

what about

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

MichalHoltz
Frequent Visitor
9 years ago
vanessafvg it works! Thanks a lot!!
Anonymous
Not applicable
7 years ago
Thanks it worked
Anonymous
Not applicable
7 years ago
@vanessafvg
Is there a way of averaging multiple columns via range instead of listing them all?
Anonymous
Not applicable
5 years ago
This doest work if one value is missed or 0 - may be any solutuon for that?

thnaks
ALeks
- Cre8
  Regular Visitor
  3 years ago
  Exactly. Is there a way to solve this problem? Have the same problem!