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 

try this measure

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

elaj's avatar
elaj
Helper IV
6 years ago

ryan_mayu 

 

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_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 🙂