Forum Discussion
Average of answer by question with multiple value types
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
Solution SageHi Max_Kloosterman,
What about the questions which are not LIKERT? The ones with OPEN Text and YN, should they not be considered?
Hi LivioLanzo,
sorry for my late reply!
The open questions can be ignored, the Y/N questions as well. The likert questions are the basis for a comparison between respondents / groups of respondents.
This is probably where I stranded, I couldn't get a measure calculated on the column containing the likert scores (as well as the other scores) to work.
Kind regards,
Max
Hi LivioLanzo
Thanks for your help and questions so far - hope the clarification helped?
Kind regards,
Max
- LivioLanzo
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
Hi LivioLanzo
Thanks and that makes sense - I should be able to figure out how to do that, part of my learning journey :-)
One follow-up question on data modelling in this respect:
There are three question types in my survey of which likert is one. Would you recommend having three different fact tables (one for the answers belonging to each question type) or instead to create three columns - one for each question type - and just have one fact table with a lot of null values?
I am using the answer table as my fact table and questions and respondents as dimension tables. Does that make sense?
Kind regards,
Max