Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
Select these 4 columns, right click and select "Unpivot Other Columns"
Hi,
Share some data and show the expected result.
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)
Hi,
In the Query Editor, unpivot all columns other than the 10 numeric columns. Write this measure
Avg = average(Data[Value])
Hope this helps.
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
Select these 4 columns, right click and select "Unpivot Other Columns"
Select these 4 columns, right click and select "Unpivot Other Columns"
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
89 | |
81 | |
65 | |
64 | |
60 |
User | Count |
---|---|
170 | |
114 | |
102 | |
73 | |
69 |