Forum Discussion

Sudharshan1919's avatar
Sudharshan1919
Helper III
2 years ago
Solved

Multiple Combination selection using Slicer

Hi All, I have a table named A where in, below values were present   Id      Region              Java                 Python             Unix                AgentsName -----------------------...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Sudharshan1919 ,

    Please try below steps:

    1. create a measure with below dax formula

    Measure =
    VAR cur_lname =
        SELECTEDVALUE ( 'Table B'[ListName] )
    VAR cur_aname =
        SELECTEDVALUE ( 'Table A'[AgentsName] )
    VAR _val =
        IF ( CONTAINSSTRING ( cur_aname, cur_lname ), 1 )
    RETURN
        IF ( NOT ( ISFILTERED ( 'Table B'[ListName] ) ), 1, _val )
    

    2. add a table visual with Table A fields, add a sclicer with Table B [ListName], add the measure to the table visual filter pan and set

    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.