Questionaire modeling

[jvandyck]

Hi

I am building a report on top of a questionaire with a multichoice question. I have a column (A-C) per  possible answer and a row per respondent. So a respondent can answer A, B or C or a combination, or nothing.

It is easy show a chart with a count of the answers per A-C. However I would also add information on the combinations, since it is a multiple choice question. Anyone any idea how to do this?

Thanks

Joos

[v-yuta-msft · Accepted solution]

@jvandyck ,

You could drag the selection column to a slicer and create a measure using dax below, then drag the measure to a card visual:

Result =
SWITCH (
    CONCATENATEX ( VALUES ( Table[Selection] ), "&" ),
    "A", "ConditionB",
    "B", "ConditionB",
    "A&B", "ConditionA&B"
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.