https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-count-row-behaves-in-denominator-in-Divide-formula/m-p/1278056#M21724 <P>OK, you've posted a measure - what's your actual question?</P> Thu, 06 Aug 2020 16:27:15 GMT jthomson 2020-08-06T16:27:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-count-row-behaves-in-denominator-in-Divide-formula/m-p/1278051#M21722 <P>AvgSalesPerDistinctProduct :=<BR />DIVIDE (<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUMX ( Sales, Sales[Quantity] * Sales[Net Price] ),<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNTROWS ( DISTINCT ( 'Product'[Product Code] ) )<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)</P> Thu, 06 Aug 2020 16:26:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-count-row-behaves-in-denominator-in-Divide-formula/m-p/1278051#M21722 Anonymous 2020-08-06T16:26:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-count-row-behaves-in-denominator-in-Divide-formula/m-p/1278056#M21724 <P>OK, you've posted a measure - what's your actual question?</P> Thu, 06 Aug 2020 16:27:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-count-row-behaves-in-denominator-in-Divide-formula/m-p/1278056#M21724 jthomson 2020-08-06T16:27:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-count-row-behaves-in-denominator-in-Divide-formula/m-p/1278084#M21726 <P>divide accepts two parameters right, so in the parameter i am multiplying th quantity with price, and the other half i did not understad can you help me understand it.&nbsp;<BR /><BR />Thanks in advance</P> Thu, 06 Aug 2020 16:44:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-count-row-behaves-in-denominator-in-Divide-formula/m-p/1278084#M21726 Anonymous 2020-08-06T16:44:18Z