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 comb...
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.

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.