topic Re: How to use OR Operator in dax calculation? in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-OR-Operator-in-dax-calculation/m-p/2265583#M54880 <P>Anonymous</LI-USER> , usage of OR with if was wrong , try like</P> <P>&nbsp;</P> <P>Product Level for Index Test = IF(ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level]) ||<BR />ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level]) ||<BR />ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level]) ||<BR />ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster]) ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])=""||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="# Exclude" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="# Exclude" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])="# Exclude" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="# Exclude" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="Exclude" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="Exclude" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])="Exclude" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="Exclude","# Exclude",RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>If need use switch</P> <P>Switch-Case statement of #PowerBI: <A href="https://www.youtube.com/watch?v=gelJWktlR80&amp;list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&amp;index=56" target="_blank">https://www.youtube.com/watch?v=gelJWktlR80&amp;list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&amp;index=56</A></P> Tue, 04 Jan 2022 13:48:48 GMT amitchandak 2022-01-04T13:48:48Z How to use OR Operator in dax calculation? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-OR-Operator-in-dax-calculation/m-p/2265490#M54869 <DIV><DIV><SPAN>How can I write this statement with OR operator so that if these conditions don't meet then I should get "Product Level"<BR /><BR />Product Level for Index = </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>ISBLANK</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level]</SPAN><SPAN>),</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>ISBLANK</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level]</SPAN><SPAN>),</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>ISBLANK</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level]</SPAN><SPAN>),</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>ISBLANK</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster]</SPAN><SPAN>),</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level]</SPAN><SPAN>)=</SPAN><SPAN>""</SPAN><SPAN>,</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level]</SPAN><SPAN>)=</SPAN><SPAN>""</SPAN><SPAN>,</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level]</SPAN><SPAN>)=</SPAN><SPAN>""</SPAN><SPAN>,</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster]</SPAN><SPAN>)=</SPAN><SPAN>""</SPAN><SPAN>,</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level]</SPAN><SPAN>)=</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level]</SPAN><SPAN>)=</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level]</SPAN><SPAN>)=</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster]</SPAN><SPAN>)=</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level]</SPAN><SPAN>)=</SPAN><SPAN>"Exclude"</SPAN><SPAN>,</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level]</SPAN><SPAN>)=</SPAN><SPAN>"Exclude"</SPAN><SPAN>,</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level]</SPAN><SPAN>)=</SPAN><SPAN>"Exclude"</SPAN><SPAN>,</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster]</SPAN><SPAN>)=</SPAN><SPAN>"Exclude"</SPAN><SPAN>,</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level]</SPAN><SPAN>))))))))))))))))</SPAN></DIV></DIV> Tue, 04 Jan 2022 12:42:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-OR-Operator-in-dax-calculation/m-p/2265490#M54869 Anonymous 2022-01-04T12:42:26Z Re: How to use OR Operator in dax calculation? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-OR-Operator-in-dax-calculation/m-p/2265500#M54870 <P>Anonymous</LI-USER> , You can use || operator or <A href="https://docs.microsoft.com/en-us/dax/or-function-dax" target="_self">OR function</A></P> <P>example</P> <P>IF(ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level] || ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level] , "# Exclude", "Other")</P> <P>&nbsp;</P> <P>You can keep on adding condition with ||</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 04 Jan 2022 12:54:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-OR-Operator-in-dax-calculation/m-p/2265500#M54870 amitchandak 2022-01-04T12:54:25Z Re: How to use OR Operator in dax calculation? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-OR-Operator-in-dax-calculation/m-p/2265519#M54874 <DIV><DIV><SPAN>Getting this error after changing to the pipe<BR /><BR />Product Level for Index Test = </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>ISBLANK</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level]</SPAN><SPAN> ||</SPAN></DIV><DIV><SPAN>ISBLANK</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level]</SPAN><SPAN> ||</SPAN></DIV><DIV><SPAN>ISBLANK</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level]</SPAN><SPAN> ||</SPAN></DIV><DIV><SPAN>ISBLANK</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster]</SPAN><SPAN> ||</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level]</SPAN><SPAN>)=</SPAN><SPAN>""</SPAN><SPAN> ||</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level]</SPAN><SPAN>)=</SPAN><SPAN>""</SPAN><SPAN> ||</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level]</SPAN><SPAN>)=</SPAN><SPAN>""</SPAN><SPAN>||</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster]</SPAN><SPAN>)=</SPAN><SPAN>""</SPAN><SPAN> ||</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level]</SPAN><SPAN>)=</SPAN><SPAN>"# Exclude"</SPAN><SPAN> ||</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level]</SPAN><SPAN>)=</SPAN><SPAN>"# Exclude"</SPAN><SPAN> ||</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level]</SPAN><SPAN>)=</SPAN><SPAN>"# Exclude"</SPAN><SPAN> ||</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster]</SPAN><SPAN>)=</SPAN><SPAN>"# Exclude"</SPAN><SPAN> ||</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level]</SPAN><SPAN>)=</SPAN><SPAN>"Exclude"</SPAN><SPAN> ||</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level]</SPAN><SPAN>)=</SPAN><SPAN>"Exclude"</SPAN><SPAN> ||</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level]</SPAN><SPAN>)=</SPAN><SPAN>"Exclude"</SPAN><SPAN> ||</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster]</SPAN><SPAN>)=</SPAN><SPAN>"Exclude"</SPAN><SPAN>,</SPAN><SPAN>"# Exclude"</SPAN><SPAN>,</SPAN><SPAN>RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level]</SPAN><SPAN>)))))))))))))))))</SPAN><img /></DIV></DIV> Tue, 04 Jan 2022 13:10:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-OR-Operator-in-dax-calculation/m-p/2265519#M54874 Anonymous 2022-01-04T13:10:40Z Re: How to use OR Operator in dax calculation? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-OR-Operator-in-dax-calculation/m-p/2265583#M54880 <P>Anonymous</LI-USER> , usage of OR with if was wrong , try like</P> <P>&nbsp;</P> <P>Product Level for Index Test = IF(ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level]) ||<BR />ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level]) ||<BR />ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level]) ||<BR />ISBLANK(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster]) ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])=""||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="# Exclude" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="# Exclude" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])="# Exclude" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="# Exclude" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Market Level])="Exclude" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])="Exclude" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Level])="Exclude" ||<BR />SELECTEDVALUE(RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Customer Cluster])="Exclude","# Exclude",RB_RGM_PAT_O_99_PowerBI_PAT_Output[◊ Product Level])</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>If need use switch</P> <P>Switch-Case statement of #PowerBI: <A href="https://www.youtube.com/watch?v=gelJWktlR80&amp;list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&amp;index=56" target="_blank">https://www.youtube.com/watch?v=gelJWktlR80&amp;list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&amp;index=56</A></P> Tue, 04 Jan 2022 13:48:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-OR-Operator-in-dax-calculation/m-p/2265583#M54880 amitchandak 2022-01-04T13:48:48Z