Forum Discussion
MS Text Filter - How to capture the text entered
Issue - I am unable to store or capture the text that was entered in the MS Text Filter. This does not work - @KeywordSearchView = SELECTEDVALUE('A'[SearchColumn]). MS Text Filter only supports ...
Greg_Deckler
Community Champion
Community ChampionMBethK SELECTEDVALUE won't work because it needs a single value to be returned. You could do something like DISTINCT('A'[SearchColumn]) and then use the IN operator for example.
Thank you Greg_Deckler regarding my use of SELECTEDVALUE.
I was incorrectly trying to use SELECTEDVALUE to capture what text was entered in the MS filter so that I determine if the text matched ColumnX and/or ColumnY, which were concatenated in 'A'[SearchColumn].
I read your help and tried the DISTINCT for SearchColumn plus and IN operator. I still couldn't check against what was typed/searched.If the user types in word 'Nurse' in the MS Filter Text , how do I capture the word 'Nurse' to see if this is the ColumnX, and/or Column Y?The result of typing 'Nurse' in the MS Text Filter will show me all 3 values in Column A, if I put column A on a table Visual. But I would only want Nurse and Nurse aides. I get Greenhouse because the text filter uses concatenated column (SearchColumn).I'm concatenating 2 fields to get a match because the text filter supports only 1 field, but I want to know if it matched column #1, and/or Column #2.ColumnA ColumnB SearchColumn (concatenated ColumnA & ColumnB) Greenhouse Nursery, Horticulture, Landscape Greenhouse - Nursery, Horticulture, Landscape Nurse Profession requires University Nurse - Profession requires University Nurse Aides Licensed Practical Nurses Nurse Aides - Licensed Practical Nurses Any additional insight is greatly appreciated .
