Forum Discussion
Bob639
1 year agoRegular Visitor
Multiple choice segment
Hello I created a multiple choice segment. I am looking to define by a measure that they are the elements to select in the segment. I created the following measurement that only works if the choic...
- 1 year ago
Use ISFILTERED to check if there's a selection in the slicer
Select_Bat = VAR _Selected = VALUES('Table'[Bat ID]) RETURN IF( ISFILTERED('Table'[Bat ID]), CONCATENATEX(_Selected, 'Table'[Bat ID], ", "), "No value selected" )Regards
Phil
Bob639
1 year agoRegular Visitor
Hello Anonymous ,
Thank you for this info.
However, it works except for a choice of zero segments via the "Select all" command, it displays them all.
Kind regards.
PhilipTreacy
1 year agoSuper User
Use ISFILTERED to check if there's a selection in the slicer
Select_Bat =
VAR _Selected = VALUES('Table'[Bat ID])
RETURN
IF(
ISFILTERED('Table'[Bat ID]), CONCATENATEX(_Selected, 'Table'[Bat ID], ", "),
"No value selected"
)
Regards
Phil