Compare survey scores

[IgorAM]

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.

[djurecicK2 · Accepted solution]

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

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

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

[IgorAM]

Thank you very much!!

[djurecicK2]

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

[IgorAM]

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.