Forum Discussion
elaj
6 years agoHelper IV
Multiple choice with Net count overcodes
Hi, I have a new problem. I am trying to visualize a question where a respondent could have multiple answers for multiple brands. I have found solutions, but they seem to me very complicated...
ryan_mayu
6 years agoSuper User
try this measure
Q N = CALCULATE(DISTINCTCOUNT(data_answers[ID_match]), data_answers[Value] = "quoted")elaj
6 years agoHelper IV
Oh yes thank you.. i think this is solving my overcode problem.
Do you have an idea for my base problem too?
I now have the base and the answers in two different tables. And this is getting quite messy when i have more of those data to visualize. Is there a way to do this more easily?
Thanks
- ryan_mayu6 years agoSuper User
i think you need to improve the data model.
in my opinion, you do not need to have both answer and answer_oc table.
Create a column in OC table
ITEM OC = SWITCH(data_answers_OC[Item],"OC_1-2","1 AND 2","oc_3-4-5","3 AND 4 AND 5",data_answers_OC[Item])Then you only need to create one group of measures.
- elaj6 years agoHelper IV
I now found out how to construct my base.
it is with the same trick. I just use distinctcount on my ID. So it only counts the respondend one time.
thanks 🙂