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
ankitkalsara
Helper I
Helper I
The solution works perfeclty well. However I need to search on the exact keywork which is not happening.
For e.g. I want to search for keyword "Star" the result is giving all the text having words "starting", "starts" etc.
Any suggestion on the above issue.
Thanks.