cancel
Showing results for
Did you mean:
Regular Visitor

## 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
Memorable Member

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.

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)

If this post helps, then please consider accepting it as the solution to help other members find it more quickly.
4 REPLIES 4
Memorable Member

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.

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)

If this post helps, then please consider accepting it as the solution to help other members find it more quickly.
Regular Visitor

Thank you very much!!

Memorable Member

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

If this post helps, then please consider accepting it as the solution to help other members find it more quickly.
Regular Visitor

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.

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors