Forum Discussion
Search for a string using a keyword table
Hi, I have a data table and a keyword table as shown in the picture. I'd like to use an slicer with the Filter Category (from the Key Table) to get data from the first table. i.e. If a select "Sect...
Hi Anonymous
It depends on what you want, if you need a column, and if you can use Power Query, go to add a column with a custom function to get your keyword column in your table_data; if you need to display the Description in a visual, then use a measure instead, I use the Filters pane to filter this test measure to "is not blank".
test = VAR CurKeyword=SELECTEDVALUE(Table_Key[Keywords]) RETURN IF(CONTAINSSTRING(MAX(Table_Data[Description]),CurKeyword),"")
Sweet!
It'd be nice to be able to use this Measure as a filter for the whole page, anyway applying the filter manually to each visual is not a big deal for now.