Weighted Average for survey score 1-10

[Ralmukhlifi97]

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

[Ashish_Mathur · Accepted 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?])