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