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: ...
  • 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
    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 🙂