https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-check-if-null-value-alert-based-other-column/m-p/2640099#M77490 <P>I have a table name called&nbsp; Local sheet . this&nbsp; table have three column Item,itemcode,</P><P>&nbsp;</P><P>Item&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Itemcode&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; weigh[g]</P><P>Shipping case&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FW002306.01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 45</P><P>Square TIN BODY&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;FW002306.01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;54</P><P>Tin Lid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;FW002306.01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;67</P><P>Tin Tape&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FW002306.01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;89</P><P>Membrane TOP&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FW002306.01</P><P>Shipping case&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FW002306.51&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 85</P><P>Square TIN BODY&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;FW002306.51&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34</P><P>Tin Lid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;FW002306.51&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;77</P><P>Tin Tape&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FW002306.51&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;89</P><P>Membrane TOP&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FW002306.51&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34</P><P>&nbsp;</P><P>I am creating new column if any&nbsp;<STRONG>weigh[g] column&nbsp;</STRONG> have a null value&nbsp; based&nbsp;Item&nbsp; column it will&nbsp; alert show WARNING or else AVAILABLE .</P><P>&nbsp;</P><P>Itemcode&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Alert&nbsp;</P><P>FW002306.01&nbsp; &nbsp; &nbsp; &nbsp; WARNING --- becaseue for this itemcode&nbsp; &nbsp;<STRONG>Membrane TOP &nbsp;</STRONG>&nbsp;item have blank so it will be warning.</P><P>FW002306.51&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;AVAILABLE&nbsp; --&nbsp;becaseue for this itemcode&nbsp; all the row have a <STRONG>weigh[g</STRONG>] value.</P><P>&nbsp;</P><P>i am trying the below measure but it is not working&nbsp;</P><P>&nbsp;</P><DIV><DIV><STRONG>Column = IF('Local FPV'[Item_Ori]=BLANK()&amp;&amp;'Local FPV'[W[g]]_1]=BLANK(),"WARNING ","AVAILABLE&nbsp; ")</STRONG></DIV><DIV>&nbsp;</DIV></DIV><P>&nbsp; looking for support .. thanks in advance ..&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> Fri, 15 Jul 2022 03:09:50 GMT Anonymous 2022-07-15T03:09:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-check-if-null-value-alert-based-other-column/m-p/2640099#M77490 <P>I have a table name called&nbsp; Local sheet . this&nbsp; table have three column Item,itemcode,</P><P>&nbsp;</P><P>Item&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Itemcode&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; weigh[g]</P><P>Shipping case&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FW002306.01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 45</P><P>Square TIN BODY&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;FW002306.01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;54</P><P>Tin Lid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;FW002306.01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;67</P><P>Tin Tape&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FW002306.01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;89</P><P>Membrane TOP&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FW002306.01</P><P>Shipping case&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FW002306.51&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 85</P><P>Square TIN BODY&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;FW002306.51&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34</P><P>Tin Lid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;FW002306.51&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;77</P><P>Tin Tape&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FW002306.51&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;89</P><P>Membrane TOP&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FW002306.51&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34</P><P>&nbsp;</P><P>I am creating new column if any&nbsp;<STRONG>weigh[g] column&nbsp;</STRONG> have a null value&nbsp; based&nbsp;Item&nbsp; column it will&nbsp; alert show WARNING or else AVAILABLE .</P><P>&nbsp;</P><P>Itemcode&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Alert&nbsp;</P><P>FW002306.01&nbsp; &nbsp; &nbsp; &nbsp; WARNING --- becaseue for this itemcode&nbsp; &nbsp;<STRONG>Membrane TOP &nbsp;</STRONG>&nbsp;item have blank so it will be warning.</P><P>FW002306.51&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;AVAILABLE&nbsp; --&nbsp;becaseue for this itemcode&nbsp; all the row have a <STRONG>weigh[g</STRONG>] value.</P><P>&nbsp;</P><P>i am trying the below measure but it is not working&nbsp;</P><P>&nbsp;</P><DIV><DIV><STRONG>Column = IF('Local FPV'[Item_Ori]=BLANK()&amp;&amp;'Local FPV'[W[g]]_1]=BLANK(),"WARNING ","AVAILABLE&nbsp; ")</STRONG></DIV><DIV>&nbsp;</DIV></DIV><P>&nbsp; looking for support .. thanks in advance ..&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> Fri, 15 Jul 2022 03:09:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-check-if-null-value-alert-based-other-column/m-p/2640099#M77490 Anonymous 2022-07-15T03:09:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-check-if-null-value-alert-based-other-column/m-p/2640148#M77495 <P>Hi,</P> <P>I assume you want to create a new column in the table.</P> <P>Please check the below picture and the attached pbix file.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <LI-CODE lang="markup">New Column CC = VAR _weightblankcount = COUNTROWS ( FILTER ( 'Local sheet', 'Local sheet'[Itemcode] = EARLIER ( 'Local sheet'[Itemcode] ) &amp;&amp; 'Local sheet'[weigh[g]]] = BLANK () ) ) RETURN IF ( _weightblankcount &gt;= 1, "Warning", "Available" )</LI-CODE> Fri, 15 Jul 2022 03:29:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-check-if-null-value-alert-based-other-column/m-p/2640148#M77495 Jihwan_Kim 2022-07-15T03:29:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-check-if-null-value-alert-based-other-column/m-p/2642406#M77629 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="291628" data-lia-user-login="Jihwan_Kim" class="lia-mention lia-mention-user">Jihwan_Kim</a>&nbsp; Thank you so much its working&nbsp;</P> Sat, 16 Jul 2022 06:04:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-check-if-null-value-alert-based-other-column/m-p/2642406#M77629 Anonymous 2022-07-16T06:04:41Z