Forum Discussion

jvandyck's avatar
jvandyck
Icon for Helper IV rankHelper IV
7 years ago
Solved

Questionaire modeling

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

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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.

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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.