How to average multiple columns to produce a box with an average I can place in a box visual

[Anonymous]

I have a survey table based on 100 employees:

All the values are whole numbers 

Table =  Survey

Columns = column1, column2, column3, column4, column5

I want to make a measure where I can place it into a box visual that shows the the Average of all the rows

Please could I have some help please.

My figures do not have any nulls or blanks

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[Anonymous]

All the columns and rows have numbers that are between 1 and 10

The average of all the columns and rows would therefore be between 1 and 10. Example:

Column1: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10

Column2: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10

Column3: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10

Column4: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10

Column5: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10

Average = 5.5 (based on 50 numbers)

[Ashish_Mathur]

Hi,

In the Query Editor, unpivot all columns other than the 10 numeric columns.  Write this measure

Avg = average(Data[Value])

Hope this helps.

[Anonymous]

Sorry I did not mention that I have columns:

Date

Employee ID

Survey ID

Survey Type ID

I decided to just add up all the columns and divide by the number of columns in a measure.

Thank you for your help anyway

[Ashish_Mathur]

Select these 4 columns, right click and select "Unpivot Other Columns"

[Ashish_Mathur · Accepted solution]

Select these 4 columns, right click and select "Unpivot Other Columns"