Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |