Forum Discussion

Bob639's avatar
Bob639
Regular Visitor
1 year ago
Solved

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

  • PhilipTreacy's avatar
    PhilipTreacy
    1 year ago

    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

5 Replies

  • Selva-Salimi's avatar
    Selva-Salimi
    Solution Sage
    1 year ago

    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.

  • FreemanZ's avatar
    FreemanZ
    Super User
    1 year ago

    hi Bob639 ,

     

    Try like:

    Select_Bat =

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

    RETURN

        IF(

            ISBLANK(_Selected);

            "No value selected";

            CONCATENATEX(

               Selected;

                Bat[bat];

                ", "

            )

        )

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.

    • Bob639's avatar
      Bob639
      Regular Visitor
      1 year ago

      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's avatar
        PhilipTreacy
        Super User
        1 year ago

        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