Dynamic filters

[Atf23]

Hi all,

Thanks in advance for any input.
I have the table CUSTOMER as follows : 

I have another table FILTER as follows :

I need to use the table FILTER to filter the table CUSTOMER by selecting the filter name from that table as follows :

I want a dynamic solution because the filter table can be modified any time and can specify a filter over one or many columns in the CUSTOMER table

Further, the value in the FILTER table can contain a list of values.

Thanks a lot

[Atf23]

@v-heq-msft, thanks for your answer. I didn't get the meaning of "combination of filters and slicers".
The dataset I provided simulates the real dataset I am working on. In fact, I cannot say in advance what column will be concerned by the predefined filters to set up the slicers or the filters in desktop. 
The solution I am looking for should allow me to translate the predefined filters set into some filed that can filter my main table (CUSTOMER) using a relationship or a comparison using DAX measure like contains.
Thanks again  

[Anonymous]

Hi @Atf23 ,
Based on your description and the data provided, the fastest way to reach your goal is to use a combination of filters and slicers as per the contents of your filter table. Since the data you provided contains ranges and character matching conditions, using multiple slicers will help you faster.

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly