Forum Discussion

Max_Kloosterman's avatar
Max_Kloosterman
Frequent Visitor
7 years ago
Solved

Average of answer by question with multiple value types

Hi,   I am analysing survey results and would like to average the answers for a subset of the questions based on their question type.   All answers are in a single column. Questiontypes are liker...
Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    Hi Max_Kloosterman,

     

    if you want to analyze just LIKERT questions, then you should import only these ones into Power BI. Do you know how to do that with Power Query?

    Once it is imported it's just a matter of defining relationships and using dax AVERAGE function

LivioLanzo's avatar
LivioLanzo
Icon for Solution Sage rankSolution Sage
7 years ago

Hi Max_Kloosterman

 

have you tried within your visual to allow for 'Show Items with No Data'?

 

 

Max_Kloosterman's avatar
Max_Kloosterman
Frequent Visitor
7 years ago

Hi LivioLanzo,

 

Not yet and your suggestion got me thinking about a solution that might work in this specific case. I will work on figuring out what might work tonight.

 

The thing is that the connector I am using to get data from surveymonkey is giving me two tables:

 

One table with all questions - essentially the questionnaire

One table with all responses - only the ones that have been selected.

 

I think I will try the following steps to get to where i need to be:

 

1. Import both tables from surveymonkey

2. join them into one table - which would indeed give me the choices that have never been selected as lines in the table with no respondents against them.

3. use that base table to create the structure you described earlier - than it might work.