undefined

[kdiallo47]

I have a variable that has single and multiple selections. I want to display a visual that shows the single and multiple selections. For instance, the variable response has the following choices: W, X,Y, Z, WX, XYZ. What is the best way to show WX and  XYZ?

[Anonymous · Accepted solution]

Hi  @kdiallo47 ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _count=COUNTX(ALLSELECTED('Table'),'Table'[Test])
return
IF(
    _count=1,MAX('Table'[Test]),
    CONCATENATEX(
        'Table','Table'[Test],""))

2. Result:

Single Choice:

Multiple choice:

Best Regards,

Liu Yang

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