Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Help with simple? contains filter

Newbie, forgive me.  I know there are lots of examples out there but none seemed to match what I'm looking for and I'm not the best in this area.

 

Hoping to get help where if a slicer name is selected, a table will display all rows where the name is found in one of two columns.  A link with a small file with the data & example is below.  I appreciate the help.

 

https://drive.google.com/open?id=194jmFZgXOz-9N-EJHYr9n50rY1fYqi2c

Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    Anonymous

     

    Hi use this measure:

     

     

    Contained =
IF (
    SELECTEDVALUE ( Names[Name] ) = SELECTEDVALUE ( Data[Assigned To] );
    1;
    IF (
        SEARCH (
            SELECTEDVALUE ( Names[Name] );
            SELECTEDVALUE ( Data[Back-up] );
            1;
            BLANK ()
        )
            = BLANK ();
        BLANK ();
        1
    )
)

    ANd use a Visual Filter int the Table Visual to Contained is 1

     

    Regards

    Victor

  • Vvelarde's avatar
    Vvelarde
    8 years ago

    Anonymous

     

    Replace ; with , 

     

    Is just Regional Settings

     

    Regards

     

     

3 Replies

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Anonymous

     

    Hi use this measure:

     

     

    Contained =
IF (
    SELECTEDVALUE ( Names[Name] ) = SELECTEDVALUE ( Data[Assigned To] );
    1;
    IF (
        SEARCH (
            SELECTEDVALUE ( Names[Name] );
            SELECTEDVALUE ( Data[Back-up] );
            1;
            BLANK ()
        )
            = BLANK ();
        BLANK ();
        1
    )
)

    ANd use a Visual Filter int the Table Visual to Contained is 1

     

    Regards

    Victor

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Get...

       

      The syntax for ';' is incorrect. (DAX(IF ( SELECTEDVALUE ( Names[Name] ) = SELECTEDVALUE ( Data[Assigned To] ); 1; IF ( SEARCH ( SELECTEDVALUE ( Names[Name] ); SELECTEDVALUE ( Data[Back-up] ); 1; BLANK () ) = BLANK (); BLANK (); 1 )))).

      • Vvelarde's avatar
        Vvelarde
        Icon for Community Champion rankCommunity Champion
        8 years ago

        Anonymous

         

        Replace ; with , 

         

        Is just Regional Settings

         

        Regards