Forum Discussion

elaj's avatar
elaj
Helper IV
6 years ago
Solved

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...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    elaj 

    try this measure

    Q N = CALCULATE(DISTINCTCOUNT(data_answers[ID_match]), data_answers[Value] = "quoted")

ryan_mayu's avatar
ryan_mayu
Super User
6 years ago

elaj 

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.

 

 

 

elaj's avatar
elaj
Helper IV
6 years ago

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 🙂