Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I would like to ask for your kind support to help me with the DAX for the weighted Average result for Survey Score.
The table is as illustrated below:
Name | How Satisfied Are you on a scale of 1-10? |
A | 5 |
B | 7 |
C | 3 |
D | 8 |
E | 10 |
F |
Keep a note that the are blank data as some did not take the survey yet and it is updated daily.
Thank you
Solved! Go to Solution.
Hi,
What do you want to weight the scores by? Just calculate a simple average. Write this measure
Avg = average(Data[How Satisfied Are you on a scale of 1-10?])
Hi,
What do you want to weight the scores by? Just calculate a simple average. Write this measure
Avg = average(Data[How Satisfied Are you on a scale of 1-10?])
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |