Change Filter condition on basis of drop down selection.

[Anonymous]

Hi i'm trying write a dax, drop down containing column list. So on selection of dropdown I can swith filter conditon from Col[A] to Col[B].

Measure:

test= calculate(distinctCount(Table1[ABC]),

                          filter(Table1,Table1[A] / Table1[B] <=max(table2[col])
                          &&

                          Table1[A] / Table1[B] >=min(table2[col])

)

So, If i select A from drop down then Table1[A] or  If i select B from drop down then Table1[B].

Is there any way I can achieve this. 

[Anonymous]

Filters( slicers, rows, columns) cannot be DAX funcitons, rather they must exists in tables in the data model. So this is a data modelling issue. Can you upload some sample data?