Forum Discussion

KarineLago's avatar
KarineLago
Advocate I
9 years ago
Solved

Use slicer as DAX argument

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!

Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    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"
    )

2 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    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"
    )