https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-exclude-some-value/m-p/3763644#M146868 <P>Hi,</P><P><BR />I'm looking for a solution to count rows but I need to exclude some data.</P><P>Now i have the following measure:</P><P>&nbsp;</P><DIV><DIV><SPAN>Count = </SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>COUNTROWS</SPAN><SPAN>(Logdata),</SPAN></DIV><DIV><SPAN>Logdata[EventType] = </SPAN><SPAN>0</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>But I need to exclude to column logdata.Datafield2 with the value "9999".</SPAN></DIV><DIV><SPAN>Any sugestions? </SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Greets, Jeffrey</SPAN></DIV></DIV> Thu, 14 Mar 2024 12:50:03 GMT Jeffrey_VC 2024-03-14T12:50:03Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-exclude-some-value/m-p/3763644#M146868 <P>Hi,</P><P><BR />I'm looking for a solution to count rows but I need to exclude some data.</P><P>Now i have the following measure:</P><P>&nbsp;</P><DIV><DIV><SPAN>Count = </SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>COUNTROWS</SPAN><SPAN>(Logdata),</SPAN></DIV><DIV><SPAN>Logdata[EventType] = </SPAN><SPAN>0</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>But I need to exclude to column logdata.Datafield2 with the value "9999".</SPAN></DIV><DIV><SPAN>Any sugestions? </SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Greets, Jeffrey</SPAN></DIV></DIV> Thu, 14 Mar 2024 12:50:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-exclude-some-value/m-p/3763644#M146868 Jeffrey_VC 2024-03-14T12:50:03Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-exclude-some-value/m-p/3763711#M146874 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="424232" data-lia-user-login="Jeffrey_VC" class="lia-mention lia-mention-user">Jeffrey_VC</a>&nbsp;</P> <P>try v2 below</P> <DIV><SPAN>Count _v2=</SPAN></DIV> <DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>COUNTROWS</SPAN><SPAN>(Logdata),<BR />Logdata[Datafield2] &lt;&gt;"9999",<BR /></SPAN></DIV> <DIV><SPAN>Logdata[EventType] =&nbsp;</SPAN><SPAN>0</SPAN><SPAN>)</SPAN></DIV> Thu, 14 Mar 2024 13:06:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-exclude-some-value/m-p/3763711#M146874 some_bih 2024-03-14T13:06:14Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-exclude-some-value/m-p/3763721#M146875 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="555045" data-lia-user-login="some_bih" class="lia-mention lia-mention-user">some_bih</a>,</P><P>&nbsp;</P><P>Thanks, this is working!</P> Thu, 14 Mar 2024 13:09:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-exclude-some-value/m-p/3763721#M146875 Jeffrey_VC 2024-03-14T13:09:49Z