topic Re: Problem with BLANK value in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-with-BLANK-value/m-p/2377201#M61305 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="364334" data-lia-user-login="Sleathbcn" class="lia-mention lia-mention-user">Sleathbcn</a>&nbsp;,</P><P>&nbsp;</P><P>How about&nbsp;</P><PRE>IF ( result = BLANK(), 0, result )</PRE><P>Does this help? <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><P>/Tom<BR /><A href="https://www.tackytech.blog/" target="_blank">https://www.tackytech.blog/</A><BR /><A href="https://www.instagram.com/tackytechtom/" target="_blank">https://www.instagram.com/tackytechtom/</A></P> Sun, 06 Mar 2022 18:48:43 GMT tackytechtom 2022-03-06T18:48:43Z Problem with BLANK value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-with-BLANK-value/m-p/2377180#M61302 <P>Hello,</P><P>I would like to know if someone can help me. In this DAX formula I would like that in case any of variables returns a BLANK value, instead of BLANK it is "Zero". Thks a lot!!</P><P>&nbsp;</P><DIV><DIV><SPAN>Deuda a LP = </SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>Deudalp</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>[BS]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>dBalance[CUENTA]</SPAN><SPAN> = </SPAN><SPAN>"170"</SPAN></DIV><BR /><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>Deudalpvinculadas</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>[BS]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>dBalance[CUENTA]</SPAN><SPAN> = </SPAN><SPAN>"160"</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>Result</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>Deudalp</SPAN><SPAN> + </SPAN><SPAN>Deudalpvinculadas</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>Result</SPAN></DIV></DIV> Sun, 06 Mar 2022 18:27:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-with-BLANK-value/m-p/2377180#M61302 Sleathbcn 2022-03-06T18:27:23Z Re: Problem with BLANK value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-with-BLANK-value/m-p/2377201#M61305 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="364334" data-lia-user-login="Sleathbcn" class="lia-mention lia-mention-user">Sleathbcn</a>&nbsp;,</P><P>&nbsp;</P><P>How about&nbsp;</P><PRE>IF ( result = BLANK(), 0, result )</PRE><P>Does this help? <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><P>/Tom<BR /><A href="https://www.tackytech.blog/" target="_blank">https://www.tackytech.blog/</A><BR /><A href="https://www.instagram.com/tackytechtom/" target="_blank">https://www.instagram.com/tackytechtom/</A></P> Sun, 06 Mar 2022 18:48:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-with-BLANK-value/m-p/2377201#M61305 tackytechtom 2022-03-06T18:48:43Z Re: Problem with BLANK value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-with-BLANK-value/m-p/2377204#M61306 <P>Yes!! Thks Tom.</P><P>Rgds</P> Sun, 06 Mar 2022 18:54:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-with-BLANK-value/m-p/2377204#M61306 Sleathbcn 2022-03-06T18:54:13Z