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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Calculating customer satisfaction scores

Hi

 

This is my first post but i have been using Power BI for a few months now. I'm struggling with getting a percentage score from DAX and need some help. I have two customer satisfaction surveys, one where 1= very good 5= very bad and another where 1=very bad and 5=very good. The calculation is the sum of all the responses / count of the number of responses.

 

I have three columns for each survey (1 header for each question). And i have the results in the rows below with another column giving me the name of the employee the survey was for

 

I've tried playing about with the below formula but it doesn't give me an individual score

 

sat score = Divide(countx('Survey,'Survey'[Q1]+'Survey'[Q2]+'Survey'[Q3]),sumx('Survey','Survey'[Q1]+'Survey'[Q2]+'Survey'[Q3]))

 

I'd appreciate any help or guidance to resolve this query which will give me an individual % score per employee for each of the two surveys

 

Many thanks

1 ACCEPTED SOLUTION
dedelman_clng
Community Champion
Community Champion

You should unpivot your data such that you table looks more like

 

Emp  SurveyID  QuestID  Score

1        1             1             1

1        1             2             2

 

etc

 

This structure will make it much easier to get individual scores.

 

Hope this helps

David

View solution in original post

1 REPLY 1
dedelman_clng
Community Champion
Community Champion

You should unpivot your data such that you table looks more like

 

Emp  SurveyID  QuestID  Score

1        1             1             1

1        1             2             2

 

etc

 

This structure will make it much easier to get individual scores.

 

Hope this helps

David

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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