Text search slicer in multiple column

[Henryk]

Hi,

I need ONE Text search slicer for search text in two column - find text in column1 OR column2. 

when I work with numbers from two columns I create measure with OR function like:

OR filtrace Odds = 1*(or([M_Odds1]>1.5,[M_Odds2]>1.4))

How can I create something similar for two text columns?

I try this solution, but not work.

[Henryk · Accepted solution]

I resolve it with COMBINEVALUES :

StateCountry = COMBINEVALUES ( "|", Customer[State], Customer[CountryRegion] )

from:

creating-a-slicer-that-filters-multiple-columns-in-power-bi

[Henryk]

Hi @hnguy7,

Thank You for reply. What is this Sample formula - measure or column? Because in column it wrote me "cannot work with String parametr" :

https://drive.google.com/file/d/1xVtsyg_VOPnqyGk_o132MucpKMHEftlp/view?usp=drivesdk

and measure I cannot add to Text search slicer.

[hnguy71]

Hi @Henryk ,

This is as a measure.

[hnguy71]

Hey @Henryk ,

Try this:

CALCULATE(SUM(<YOUR_TABLE>[Your_Value]), (<YOUR_TABLE>[Column1] = "String01") || (<YOUR_TABLE>[Column2] = "String02"))