Forum Discussion
Solved
Dynamic filtering/slicing if text contains
I have the following data: Date Text
2018-11-01 This is some random text
2018-04-03 Some test mumbling here
2018-02-01 Whatever we write here I have a visual (line chart) displayin...
Hi DennisGaida
May be you could use a MEASURE like
Measure = VAR searchvalue = SEARCH ( SELECTEDVALUE ( Text_Queries[Column1] ), SELECTEDVALUE ( Table1[Text] ), , BLANK () ) RETURN IF ( searchvalue > 0, "Found" )See the attached file. I am not sure if this what you need
Zubair_Muhammad
Community Champion
Community ChampionHi DennisGaida
May be you could use a MEASURE like
Measure =
VAR searchvalue =
SEARCH (
SELECTEDVALUE ( Text_Queries[Column1] ),
SELECTEDVALUE ( Table1[Text] ),
,
BLANK ()
)
RETURN
IF ( searchvalue > 0, "Found" )See the attached file. I am not sure if this what you need
Thanks for the soluton. however, It works for single selection, but it does not work with multiple selection, do you what is the possible reason for this?