https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-level-value-check-if-value-null-return-warning-if-value/m-p/2640159#M77496 <P>Anonymous</LI-USER> , Try a measure like </P> <P>&nbsp;</P> <P>ALERT = IF(countx(filter(allselected(LOCALFPV), LOCALFPV[Itemcode] = max(LOCALFPV[Itemcode]) <BR />&amp;&amp; LOCALFPV[Plant] = max(LOCALFPV[Plant]) &amp;&amp; Isblank([weight]) ), LOCALFPV[Itemcode] ) &gt;0 ,"WARNING","AVAILABLE")</P> Fri, 15 Jul 2022 03:38:25 GMT amitchandak 2022-07-15T03:38:25Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-level-value-check-if-value-null-return-warning-if-value/m-p/2639240#M77457 <P>I have&nbsp; single table name called Local FPV.&nbsp; &nbsp;please find the below sample Data set&nbsp;</P><P>&nbsp;</P><P>&nbsp;item&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BOM&nbsp; BOM Level&nbsp; &nbsp; &nbsp; Plant&nbsp; &nbsp; &nbsp; Item(BOM)&nbsp; &nbsp; &nbsp;2D-Length&nbsp; &nbsp; &nbsp;2D-Width&nbsp; &nbsp; &nbsp;weight[g]&nbsp; &nbsp; Itemcode</P><P>Shipping case&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;70&nbsp; &nbsp;Case - CAS&nbsp; &nbsp; &nbsp; CZ71&nbsp; &nbsp; &nbsp; 70.W398&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;293&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;236&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 324&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FW001691.13</P><P>Shipping case&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;87&nbsp; &nbsp;Case - CAS&nbsp; &nbsp; &nbsp; DE19&nbsp; &nbsp; &nbsp;&nbsp;70.W398&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;293&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;236&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 321&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FW001691.13</P><P>Square TIN BODY&nbsp; &nbsp; &nbsp; &nbsp;70&nbsp; &nbsp;PAK1 - PAK1&nbsp; &nbsp; CZ71&nbsp; &nbsp; &nbsp; 87.1445&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 226&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;112&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FW001691.13</P><P><STRONG>Square TIN BODY&nbsp; &nbsp; &nbsp; &nbsp;87&nbsp; &nbsp;PAK1 - PAK1&nbsp; &nbsp; DE19&nbsp; &nbsp; &nbsp;&nbsp;87.1445&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 226&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;112&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FW001691.13</STRONG></P><P>&nbsp;</P><P>&nbsp;</P><P>Now i am adding the&nbsp; &nbsp;weight[g]&nbsp; value based on the Itemcode like below&nbsp; added table graph&nbsp;</P><P>&nbsp;</P><P>Itemcode&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Plant&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; weight&nbsp;</P><P>FW001691.13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CZ71&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;354</P><P>FW001691.13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DE19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;321</P><P>&nbsp;</P><P>Next trying add new column if weight[g]&nbsp; value null in Particular <STRONG>Itemcode</STRONG>&nbsp; any column&nbsp; . it will be warning i have added below dax code&nbsp;</P><P>&nbsp;</P><P><STRONG>ALERT = IF(LOCALFPV(weight[g]=BLANK(),"WARNING","AVAILABLE")</STRONG></P><P>&nbsp;</P><P>when i add this column in to the above i am getting duplicate code&nbsp;</P><P>&nbsp;</P><P>Itemcode&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Plant&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; weight&nbsp; &nbsp; &nbsp; &nbsp; <STRONG>ALERT </STRONG></P><P>FW001691.13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CZ71&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;354&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<STRONG>AVAILABLE</STRONG>&nbsp;</P><P>FW001691.13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CZ71&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;354&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<STRONG>WARNING</STRONG></P><P>FW001691.13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DE19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;321&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<STRONG>AVAILABLE</STRONG></P><P>FW001691.13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DE19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;321&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<STRONG>WARNING</STRONG> &nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>But Expect output&nbsp; &nbsp;Correct result below&nbsp;</P><P>Itemcode&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Plant&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; weight&nbsp; &nbsp; &nbsp; &nbsp; <STRONG>ALERT </STRONG></P><P>&nbsp;</P><P>FW001691.13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CZ71&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;354&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<STRONG>WARNING</STRONG></P><P>&nbsp;</P><P>FW001691.13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DE19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;321&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<STRONG>WARNING</STRONG> &nbsp;</P><P>&nbsp;</P><P>Looking for support . thanks in advance .</P> Thu, 14 Jul 2022 15:31:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-level-value-check-if-value-null-return-warning-if-value/m-p/2639240#M77457 Anonymous 2022-07-14T15:31:39Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-level-value-check-if-value-null-return-warning-if-value/m-p/2640159#M77496 <P>Anonymous</LI-USER> , Try a measure like </P> <P>&nbsp;</P> <P>ALERT = IF(countx(filter(allselected(LOCALFPV), LOCALFPV[Itemcode] = max(LOCALFPV[Itemcode]) <BR />&amp;&amp; LOCALFPV[Plant] = max(LOCALFPV[Plant]) &amp;&amp; Isblank([weight]) ), LOCALFPV[Itemcode] ) &gt;0 ,"WARNING","AVAILABLE")</P> Fri, 15 Jul 2022 03:38:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-level-value-check-if-value-null-return-warning-if-value/m-p/2640159#M77496 amitchandak 2022-07-15T03:38:25Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-level-value-check-if-value-null-return-warning-if-value/m-p/2640740#M77516 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="148838" data-lia-user-login="amitchandak" class="lia-mention lia-mention-user">amitchandak</a>&nbsp; sir i am tried&nbsp; above measure but i am getting available only for the all the item code&nbsp;</P> Fri, 15 Jul 2022 08:45:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-level-value-check-if-value-null-return-warning-if-value/m-p/2640740#M77516 Anonymous 2022-07-15T08:45:04Z