I am going to build a model for survey data.
Has anyone here modeled a survey before? I am wondering how I can best structure the data so I can filter using the answers from multiple questions.
For example, if I have 10 questions in the survey and want to use the answers from 3 questions to filter the visual for a 4th question. ie using answers to questions 1, 3, 5 as slicers for question 10. Or perhaps using answers to questions 10, 5, and 3 to filter question 1 etc…
This would allow me to really drill into the survey BUT I’m not really sure the bets way to build the data model to do that.