Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Change Filter condition on basis of drop down selection.

Capture1.JPG

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. 

                                 
           

1 REPLY 1
Anonymous
Not applicable

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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors