Forum Discussion
Text search slicer in multiple column
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.
I resolve it with COMBINEVALUES :
StateCountry = COMBINEVALUES ( "|", Customer[State], Customer[CountryRegion] )
from:
4 Replies
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.
I resolve it with COMBINEVALUES :
StateCountry = COMBINEVALUES ( "|", Customer[State], Customer[CountryRegion] )
from:
