topic Re: Multiple choice segment in DAX Commands and Tips

Multiple choice segment

Bob639 — Thu, 24 Oct 2024 13:27:16 GMT

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 choice is single but not multiple.

Select_Bat =

VAR _Selected = SELECTEDVALUE('Bat'[Bat])

RETURN

IF(

ISBLANK(_Selected);

"No value selected";

CONCATENATEX(

Batiment;

_Selected;

", "

)

Do you have a solution ?

Kind regards.

Re: Multiple choice segment

Selva-Salimi — Thu, 24 Oct 2024 13:39:56 GMT

Hi Bob639

I think you need to use "Values" instead of "selectedvalue".

If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.

Re: Multiple choice segment

FreemanZ — Thu, 24 Oct 2024 14:36:28 GMT

hi Bob639 ,

Try like:

Select_Bat =

VAR _Selected = VALUES('Bat'[Bat])

RETURN

IF(

ISBLANK(_Selected);

"No value selected";

CONCATENATEX(

Selected;

Bat[bat];

", "

)

Re: Multiple choice segment

Anonymous — Wed, 30 Oct 2024 08:18:40 GMT

Hi Bob639 ,

Based on your description, I created these data.

Create the measure.

Select_Bat = VAR _Selected = VALUES('Table'[Bat ID]) RETURN IF( COUNTROWS(_Selected) = 0, "No value selected", CONCATENATEX( _Selected, 'Table'[Bat ID], ", " ) )

The final result is shown below. More details can be found in the attachment.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Multiple choice segment

Bob639 — Wed, 30 Oct 2024 09:27:48 GMT

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.

Re: Multiple choice segment

PhilipTreacy — Wed, 30 Oct 2024 09:52:45 GMT

Bob639

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