Forum Discussion
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.
Hi Anonymous ,
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!
4 Replies
- djurecic
Super User
Hi Anonymous ,
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.
- djurecic
Hi Anonymous ,
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!