Use slicer as DAX argument

[KarineLago]

Hi guys!

Is there a way to use an auxiliar table (as slicer) with values to search in the DAX below, instead of writing the string to search?

Eg: the string "Beer" would be modified by the value selected in the slicer.

Coluna = IF (
ISBLANK ( SEARCH ( "Beer"; 'Speech Lines'[text]; 1; BLANK () ) );
"Not Found";
"Found"
)

Thanks in advance!

[Vvelarde · Accepted solution]

@KarineLago

Hi, In a calculated Column is not possible.

Is possible in a measure. 

Coluna = IF (
ISBLANK ( SEARCH ( Values(Auxiliar[SlicerValue]); Values('Speech Lines'[text]); 1; BLANK () ) );
"Not Found";
"Found"
)

[KarineLago]

Thanks @Vvelarde!