Or condition on multiple columns

Question

Hi&nbsp;I want to apply or condition on multiple columns. for example&nbsp;col1col2&nbsp; &nbsp; &nbsp; &nbsp;col3&nbsp;col4&nbsp;want to apply or condition on the above columns&nbsp;then and condition&nbsp;col5col6col7&nbsp;and condition on above 3&nbsp;and again want to apply and condition for the above two results, col1 to col7 are columns in a single table.&nbsp;&nbsp;{col1 or col2 or col3 or col4}&nbsp;&nbsp;&nbsp; and {col5 and col6 and col7}

v-lili6-msft · Accepted Answer

hi,&nbsp;Anonymous&nbsp;
You could use || in the dax formula,&nbsp; it will be a little bit cleaner.
https://docs.microsoft.com/en-us/dax/dax-operator-reference
&nbsp;
So like this:
CALCULATE&nbsp;( &lt;expression&gt;&nbsp;,&nbsp;Filter( Table, ( [col1] ||&nbsp;[col2] ||&nbsp;[col3] ||&nbsp;[col4] ) &amp;&amp;&nbsp;( [col5] ||&nbsp;[col6] ||&nbsp;[col7]&nbsp;) ) )
And you could also use AND and OR for&nbsp;nesting in formulas
CALCULATE&nbsp;(&nbsp;&lt;expression&gt;&nbsp;,FILTER&nbsp;(&nbsp;Table,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AND&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OR&nbsp;(&nbsp;OR&nbsp;(&nbsp;OR&nbsp;(&nbsp;[col1],&nbsp;[col2]&nbsp;),&nbsp;[col3]&nbsp;),&nbsp;[col4]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OR&nbsp;(&nbsp;OR&nbsp;(&nbsp;[col5],&nbsp;[col6]&nbsp;),&nbsp;[col7]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;))
&nbsp;
&nbsp;
Best Regards,
Lin

Forum Discussion

Or condition on multiple columns

1 Reply

Related content

Conditional Column with Multiple Conditions

Multiple conditions Index

Conditional Column with Multiple Conditions

Dynamical conditional formatting for multiple columns

Multiple Donut charts with conditions