Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Ralmukhlifi97
New Member

Weighted Average for survey score 1-10

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?
A5
B7
C3
D8
E10
F 

 

Keep a note that the are blank data as some did not take the survey yet and it is updated daily. 

 

Thank you

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

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?])


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

1 REPLY 1
Ashish_Mathur
Super User
Super User

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?])


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.