Showing results for 
Search instead for 
Did you mean: 
dheer1688 Regular Visitor
Regular Visitor

Change Filter condition on basis of drop down selection.


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].


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. 


Super User
Super User

Re: Change Filter condition on basis of drop down selection.

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?

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 148 members 1,833 guests
Please welcome our newest community members: