Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |