https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Changing-blank-to-0/m-p/3276726#M121556 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;<BR />Please try</P> <P><SPAN>COUNTROWS&nbsp;</SPAN><SPAN>(&nbsp;</SPAN><SPAN>SalesOrders&nbsp;</SPAN><SPAN>)&nbsp; + 0</SPAN></P> Fri, 09 Jun 2023 13:52:44 GMT tamerj1 2023-06-09T13:52:44Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Changing-blank-to-0/m-p/3276570#M121551 <P>Hello,&nbsp;</P><P>&nbsp;</P><P>I have a matrix in my Power Bi report&nbsp; that shows Sales Orders by year. However, some products have no sales in some months and the DAX I currently use returns blanks instead 0.&nbsp;</P><P>&nbsp;</P><P>I need the DAX to return 0 instead of blank. My current DAX is&nbsp;&nbsp;<SPAN>COUNTROWS</SPAN><SPAN>(</SPAN><SPAN>SalesOrders</SPAN><SPAN>)&nbsp;</SPAN></P><P>&nbsp;</P><P>Can anyone help?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 09 Jun 2023 12:35:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Changing-blank-to-0/m-p/3276570#M121551 Anonymous 2023-06-09T12:35:47Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Changing-blank-to-0/m-p/3276726#M121556 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;<BR />Please try</P> <P><SPAN>COUNTROWS&nbsp;</SPAN><SPAN>(&nbsp;</SPAN><SPAN>SalesOrders&nbsp;</SPAN><SPAN>)&nbsp; + 0</SPAN></P> Fri, 09 Jun 2023 13:52:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Changing-blank-to-0/m-p/3276726#M121556 tamerj1 2023-06-09T13:52:44Z