using a filter to search through a field

[bwhitlock]

I have two columns

Column 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,  Record 1 - " Beer", Record 2 -"Beer Wine", Record 3 - "Wine Spirits"

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. 

Is this possible?

[bwhitlock]

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

[mwegener]

I would have the following sample

[bwhitlock]

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?

[mwegener]

Hello @bwhitlock,

this should already be the case now.

[mwegener]

Do you have sample data?

[mwegener]

Hi @bwhitlock ,

I think you can create something like this with DAX CONTAINSSTRING.

https://dax.guide/containsstring/