Forum Discussion

ShivGC's avatar
ShivGC
Helper I
2 years ago
Solved

Multiple Select option

Hi  I couldn't quite find the answer to my question online so I decided to drop the question on the forums myself.    I have two tables that have no relationship Client (Distinct) Table: ...
"DAX"
"Help"
"Need Help"
"SELECTEDVALUE"
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ShivGC ,

    Please try to create a measure with below dax formula:

    Measure =
VAR _a =
    SELECTEDVALUE ( 'Client  Information'[Client ] )
VAR tmp =
    SELECTCOLUMNS ( Client, "Client Name", [Client] )
VAR _str =
    CONCATENATEX ( tmp, [Client Name], "," )
VAR _result =
    IF ( CONTAINSSTRING ( _str, _a ), "#006D9E", "#A6E2EF" )
RETURN
    _result

    Add a scatter visual with Client Information table, and set the markers color

     

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • ShivGC's avatar
    ShivGC
    2 years ago
    IsTable1InTable2 = 
IF(
    COUNTROWS(
        FILTER(
            'Table1',
            'Table1'[ColumnName] IN VALUES('Table2'[ColumnName])
        )
    ) > 0,
    TRUE,
    FALSE
)



    Here is a code that worked for me 🙂

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ShivGC ,

Please try to create a measure with below dax formula:

Measure =
VAR _a =
    SELECTEDVALUE ( 'Client  Information'[Client ] )
VAR tmp =
    SELECTCOLUMNS ( Client, "Client Name", [Client] )
VAR _str =
    CONCATENATEX ( tmp, [Client Name], "," )
VAR _result =
    IF ( CONTAINSSTRING ( _str, _a ), "#006D9E", "#A6E2EF" )
RETURN
    _result

Add a scatter visual with Client Information table, and set the markers color

 

Please refer the attached .pbix file.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ShivGC's avatar
ShivGC
Helper I
2 years ago

Do you know why the Selected value function does not work for multiple select? 

I wanted to use an alternative of the selected value so I could use it in the calculate function too. 

I do not undertsand why Selectedvalue will not work when I select more than one value?

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
    Do you know why the Selected value function does not work for multiple select?

    For that you need to use VALUES()

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ShivGC ,

    For Selectedvalue() function, it return the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult.

    When you select more than one value in slicer, it will return blank when not set the second parameter.

     

    For more details, you can read related document: SELECTEDVALUE function - DAX | Microsoft Learn

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.