Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |