Help with simple? contains filter

[Anonymous]

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

[Vvelarde · Accepted solution]

@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 · Accepted solution]

@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]

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 · Accepted solution]

@Anonymous

Replace ; with , 

Is just Regional Settings

Regards