https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/CountRows/m-p/3465044#M132222 <P>hi,&nbsp;Anonymous</LI-USER>&nbsp;<BR />&nbsp;i think in your code it count blank row also if blank row present in your data<BR />try below measure</P><P>&nbsp;</P><DIV><DIV><STRONG>count =</STRONG></DIV><DIV><STRONG>&nbsp;var curr = MAX(Sheet1[HMI])</STRONG></DIV><DIV><STRONG>&nbsp;return</STRONG></DIV><DIV><STRONG>&nbsp;COUNTX(FILTER(ALL(Sheet1),Sheet1[HMI]&lt;curr),Sheet1[HMI])</STRONG></DIV><DIV>&nbsp;</DIV><DIV><STRONG><FONT size="3">If this post&nbsp;helps, then please consider&nbsp;Accepting it as the solution&nbsp;to help the other members find it more quickly.</FONT><FONT color="#333399"><SPAN><I>&nbsp;</I><FONT size="3" color="#000000">Appreciate your kudos</FONT></SPAN></FONT></STRONG></DIV></DIV> Sat, 07 Oct 2023 13:06:37 GMT Dangar332 2023-10-07T13:06:37Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/CountRows/m-p/3464822#M132217 <P>Hi Everyone,</P><P>&nbsp;</P><P>Need your help on this. I'm trying to compare each value and count if it's less than, but it's not giving me the correct count. Any help is much appreciated. I have shared a link for the data.&nbsp;<BR />Here's the&nbsp;<A href="https://docs.google.com/spreadsheets/d/1n56Busm30-LeHMcAkmkRjW18gMw26DE5/edit?usp=sharing&amp;ouid=110820996605556538896&amp;rtpof=true&amp;sd=true" target="_self">data</A>.</P><P>&nbsp;</P><P><img /></P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 07 Oct 2023 02:18:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/CountRows/m-p/3464822#M132217 Anonymous 2023-10-07T02:18:08Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/CountRows/m-p/3465044#M132222 <P>hi,&nbsp;Anonymous</LI-USER>&nbsp;<BR />&nbsp;i think in your code it count blank row also if blank row present in your data<BR />try below measure</P><P>&nbsp;</P><DIV><DIV><STRONG>count =</STRONG></DIV><DIV><STRONG>&nbsp;var curr = MAX(Sheet1[HMI])</STRONG></DIV><DIV><STRONG>&nbsp;return</STRONG></DIV><DIV><STRONG>&nbsp;COUNTX(FILTER(ALL(Sheet1),Sheet1[HMI]&lt;curr),Sheet1[HMI])</STRONG></DIV><DIV>&nbsp;</DIV><DIV><STRONG><FONT size="3">If this post&nbsp;helps, then please consider&nbsp;Accepting it as the solution&nbsp;to help the other members find it more quickly.</FONT><FONT color="#333399"><SPAN><I>&nbsp;</I><FONT size="3" color="#000000">Appreciate your kudos</FONT></SPAN></FONT></STRONG></DIV></DIV> Sat, 07 Oct 2023 13:06:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/CountRows/m-p/3465044#M132222 Dangar332 2023-10-07T13:06:37Z