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 want to apply or condition on multiple columns. for example
col1
col2
col3
col4
want to apply or condition on the above columns
then and condition
col5
col6
col7
and condition on above 3
and again want to apply and condition for the above two results, col1 to col7 are columns in a single table.
{col1 or col2 or col3 or col4} and {col5 and col6 and col7}
Solved! Go to Solution.
hi, @Anonymous
You could use || in the dax formula, it will be a little bit cleaner.
https://docs.microsoft.com/en-us/dax/dax-operator-reference
So like this:
CALCULATE ( <expression> , Filter( Table, ( [col1] || [col2] || [col3] || [col4] ) && ( [col5] || [col6] || [col7] ) ) )
And you could also use AND and OR for nesting in formulas
CALCULATE ( <expression> ,FILTER ( Table,
AND (
OR ( OR ( OR ( [col1], [col2] ), [col3] ), [col4] ),
OR ( OR ( [col5], [col6] ), [col7] )
)
))
Best Regards,
Lin
hi, @Anonymous
You could use || in the dax formula, it will be a little bit cleaner.
https://docs.microsoft.com/en-us/dax/dax-operator-reference
So like this:
CALCULATE ( <expression> , Filter( Table, ( [col1] || [col2] || [col3] || [col4] ) && ( [col5] || [col6] || [col7] ) ) )
And you could also use AND and OR for nesting in formulas
CALCULATE ( <expression> ,FILTER ( Table,
AND (
OR ( OR ( OR ( [col1], [col2] ), [col3] ), [col4] ),
OR ( OR ( [col5], [col6] ), [col7] )
)
))
Best Regards,
Lin
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |