using a filter to search through a field

Question

I have two columnsColumn A called Market will be used as a slicer. It contains record 1 - "Beer" and record 2 - "Wine"Column B Called Type is the column the slicer should filter... It contains 3 records,&nbsp; Record 1 - " Beer", Record 2 -"Beer Wine", Record 3 - "Wine Spirits"&nbsp;If I choose Beer from Column A Id like it to filter on Record 1 and 2 in Column B. So essentially its searching through the record to find that text. If I filter Column B on Wine, it should come back with Record 2 and 3.&nbsp;&nbsp;Is this possible?

mwegener · Answer

Hi&nbsp;bwhitlock&nbsp;,
I think you can create something like this with DAX CONTAINSSTRING.
https://dax.guide/containsstring/
&nbsp;

bwhitlock · Answer

thanks for the feedback. How would I pass the parameter from Column A to this however.

mwegener · Answer

Do you have sample data?

mwegener · Answer

I would have the following sample

bwhitlock · Answer

thanks so much for the example. Question. Is there a way to set the measure so if someone does not select a choice is shows the full list?

Forum Discussion

using a filter to search through a field

6 Replies

Related content

How to search specific word in table filter Calculations

Slicer Search Bar

Jump searching text not filter

Search text within drop down filter

search values to filter