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
IgorAM
Helper I
Helper I

Compare survey scores

Hi guys,

 

I have a table with the following columns

 

NPS Survey: Column with the survey, for example, 1st survey, 2nd survey, 3th survey

NPS Score: Column with the score for each answer, for example, 0, 1, 2, 3,...10

NPS e-mail: Column with the e-mail that sent the answer

 

What I need is an average of NPS Score from the e-mails who answer the all the 3 surveys. Some e-mails just answered the first survey, some just the seconde or third, what I need its a measure that considers just the e-mails that answer the 3 surveys.

 

The objective it is to compare the score of the 1st survey, with the 2nd and 3 survey, but just looking for the e-mails who follow the rule above.

1 ACCEPTED SOLUTION
djurecicK2
Super User
Super User

Hi @IgorAM ,

 Here is one way to do it- by creating a calculated column to see how many reponses per email, then summarize the table to show only emails with 3 responses.

(adapt to your table and field names)

 
Survey Responses = COUNTROWS(FILTER('SurveyTable', (EARLIER('SurveyTable'[e-mail])= 'SurveyTable'[e-mail])))
 

djurecicK2_0-1669744272748.png

 

3 Responses = CALCULATETABLE(SUMMARIZE(SurveyTable,SurveyTable[e-mail], "Surveys", AVERAGE(SurveyTable[Survey Responses])), SurveyTable[Survey Responses] >=3)
 
djurecicK2_1-1669744489134.png

 

Please accept as solution if this has answered the question- thanks!

View solution in original post

4 REPLIES 4
djurecicK2
Super User
Super User

Hi @IgorAM ,

 Here is one way to do it- by creating a calculated column to see how many reponses per email, then summarize the table to show only emails with 3 responses.

(adapt to your table and field names)

 
Survey Responses = COUNTROWS(FILTER('SurveyTable', (EARLIER('SurveyTable'[e-mail])= 'SurveyTable'[e-mail])))
 

djurecicK2_0-1669744272748.png

 

3 Responses = CALCULATETABLE(SUMMARIZE(SurveyTable,SurveyTable[e-mail], "Surveys", AVERAGE(SurveyTable[Survey Responses])), SurveyTable[Survey Responses] >=3)
 
djurecicK2_1-1669744489134.png

 

Please accept as solution if this has answered the question- thanks!

Thank you very much!!

djurecicK2
Super User
Super User

Hi @IgorAM ,

 Could you please post an image of your table? Seems like you can accomplish this with IF and ISBLANK statements.

 

https://learn.microsoft.com/en-us/dax/isblank-function-dax

 

Hi djurecicK2,

 

Here is an example. Note that the emails eee@gmail, bbb@outlook and ccc@yahoo answered the three surveys, so I need to look only for them in the measure and ignore the others.

 

IgorAM_0-1669736375151.png

 

 

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.

Top Solution Authors