Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
27 | |
26 |
User | Count |
---|---|
97 | |
96 | |
59 | |
44 | |
40 |