Average of different columns

[rayinOz]

Hello PowerBI Users!

So I have a table with results from a survey. Each row represents a response from a survey and each column represents a question. 

I have three questions each represented by a value of 1 through 5 and each in their own column (see image below). 

What I'm wanting is to get an average of all responses from all three questions. What's the best way to do this? 

Thanks so much in advance. 

Ray

[Ashish_Mathur]

Hi,

In the Query Editor, right click on the Respondent column and select "Unpivot other columns".  Click on Close and Apply.  To your card visual, drag these measures

Clear score = calculate(average(data[value]),data[attribute]="clear")

Facilitator score = calculate(average(data[value]),data[attribute]="facilitator")

Pace score = calculate(average(data[value]),data[attribute]="pace")

Hope this helps.

[v-robertq-msft · Accepted solution]

Hi, @rayinOz 

According to your description, you want to calculate the average value for all three columns, I think the easiest way to achieve this is creating a Matrix/table and set the data summarize type, you can follow my steps:

Create a Matrix/table and place the three columns into it, then set the value to “Average”, like this:

And you can get what you want, like this:

You can download my test pbix file here

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

Hi @rayinOz 

Example PBIX file here

Create 3 measures, one each for the average of each column e.g.

Avg clear = AVERAGE([clear])

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.