topic Re: How to count rows of column after a filter expressions (not using calculate) in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-rows-of-column-after-a-filter-expressions-not-using/m-p/3300148#M123062 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="560127" data-lia-user-login="ARK8" class="lia-mention lia-mention-user">ARK8</a>&nbsp;</P> <P>Please try</P> <P>Count =<BR />COUNTROWS (<BR />SUMMARIZE (<BR />FILTER ( Sales, RELATED ( Customer[CustomerType] ) = "L" ),<BR />Customer[Customer Key]<BR />)<BR />)</P> Fri, 23 Jun 2023 16:20:38 GMT tamerj1 2023-06-23T16:20:38Z How to count rows of column after a filter expressions (not using calculate) https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-rows-of-column-after-a-filter-expressions-not-using/m-p/3300133#M123061 <P>Table Customer&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Customer Key</TD><TD>Customer Type</TD></TR><TR><TD>1</TD><TD>L</TD></TR><TR><TD>2</TD><TD>S</TD></TR><TR><TD>3</TD><TD>L</TD></TR><TR><TD>4</TD><TD>S</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Sales Table&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Sale Qty</TD><TD>Sale price</TD><TD>Customer ID</TD></TR><TR><TD>50</TD><TD>2</TD><TD>1</TD></TR><TR><TD>20</TD><TD>5</TD><TD>2</TD></TR><TR><TD>10</TD><TD>10</TD><TD>3</TD></TR><TR><TD>100</TD><TD>30</TD><TD>4</TD></TR><TR><TD>200</TD><TD>8</TD><TD>3</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I am trying to count distinct customers for a particular type&nbsp; who made sale using Filters (strictly not by calculate)&nbsp;<BR />&nbsp;So far I came up with this :&nbsp;</P><P>&nbsp; &nbsp; FILTER ( Sales,</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Related(Customer[CustomerType] = "L"</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)</P><P>&nbsp;not sure who do I go from here.</P> Fri, 23 Jun 2023 16:11:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-rows-of-column-after-a-filter-expressions-not-using/m-p/3300133#M123061 ARK8 2023-06-23T16:11:21Z Re: How to count rows of column after a filter expressions (not using calculate) https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-rows-of-column-after-a-filter-expressions-not-using/m-p/3300148#M123062 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="560127" data-lia-user-login="ARK8" class="lia-mention lia-mention-user">ARK8</a>&nbsp;</P> <P>Please try</P> <P>Count =<BR />COUNTROWS (<BR />SUMMARIZE (<BR />FILTER ( Sales, RELATED ( Customer[CustomerType] ) = "L" ),<BR />Customer[Customer Key]<BR />)<BR />)</P> Fri, 23 Jun 2023 16:20:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-rows-of-column-after-a-filter-expressions-not-using/m-p/3300148#M123062 tamerj1 2023-06-23T16:20:38Z