https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/not-exists/m-p/1519089#M29583 <P>Anonymous</LI-USER> , Try a new column like</P> <P>&nbsp;</P> <P>new complete flag =<BR />var _cnt = countx(filter(Table,[order id] =earlier([order id]) &amp;&amp; [status] ="Complete"),[order id] )+0 <BR />return <BR />if(_cnt&gt;=1, "Y",[complete flag])</P> Thu, 26 Nov 2020 14:41:59 GMT amitchandak 2020-11-26T14:41:59Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/not-exists/m-p/1518933#M29574 <P>Hi&nbsp;</P><P>i need to achive below&nbsp; table in powerbi if any order id having status as complete i need to mark all rows for that order id as Y</P><P>can you please help&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>order id</TD><TD>Status</TD><TD>complete flag</TD></TR><TR><TD>244968</TD><TD>Complete</TD><TD>Y</TD></TR><TR><TD>244968</TD><TD>open</TD><TD>Y</TD></TR><TR><TD>244968</TD><TD>cancel</TD><TD>Y</TD></TR><TR><TD>269287</TD><TD>open</TD><TD>N</TD></TR><TR><TD>344968</TD><TD>Complete</TD><TD>Y</TD></TR></TBODY></TABLE> Thu, 26 Nov 2020 13:15:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/not-exists/m-p/1518933#M29574 Anonymous 2020-11-26T13:15:41Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/not-exists/m-p/1519089#M29583 <P>Anonymous</LI-USER> , Try a new column like</P> <P>&nbsp;</P> <P>new complete flag =<BR />var _cnt = countx(filter(Table,[order id] =earlier([order id]) &amp;&amp; [status] ="Complete"),[order id] )+0 <BR />return <BR />if(_cnt&gt;=1, "Y",[complete flag])</P> Thu, 26 Nov 2020 14:41:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/not-exists/m-p/1519089#M29583 amitchandak 2020-11-26T14:41:59Z