Forum Discussion
undefined
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?
Hi Anonymous ,
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
1 Reply
Hi Anonymous ,
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