https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calculate-the-sum-of-cost-divide-by-count-of-cost/m-p/1379678#M25212 <P>Super thanks amit!!</P> Fri, 18 Sep 2020 10:07:25 GMT Anonymous 2020-09-18T10:07:25Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calculate-the-sum-of-cost-divide-by-count-of-cost/m-p/1379464#M25203 <P>I have a question of calculating the total cost of each work order divided by the count of cost. There are duplicates in the total cost for each work order and the count is used to get the actual cost. See example below, where sometimes the cost is duplicated three or two times etc.&nbsp;&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>I used Quoted Cost = DIVIDE([Planned Cost],[Count of Planned Cost]). Each line looks okay, but when you look at the aggregated quoted cost, the quoted cost is wrong as it uses 621084/ 415 = 1497. I need the aggregate of quoted cost by summing up each line of the quoted cost.&nbsp;</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Appreciate any help.</SPAN></DIV></DIV><P>&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Fri, 18 Sep 2020 08:22:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calculate-the-sum-of-cost-divide-by-count-of-cost/m-p/1379464#M25203 Anonymous 2020-09-18T08:22:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calculate-the-sum-of-cost-divide-by-count-of-cost/m-p/1379502#M25205 <P>Anonymous</LI-USER> ,</P> <P>sumx( values(Table[Work Order]),Quoted Cost = DIVIDE([Planned Cost],[Count of Planned Cost]))</P> Fri, 18 Sep 2020 08:36:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calculate-the-sum-of-cost-divide-by-count-of-cost/m-p/1379502#M25205 amitchandak 2020-09-18T08:36:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calculate-the-sum-of-cost-divide-by-count-of-cost/m-p/1379678#M25212 <P>Super thanks amit!!</P> Fri, 18 Sep 2020 10:07:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Calculate-the-sum-of-cost-divide-by-count-of-cost/m-p/1379678#M25212 Anonymous 2020-09-18T10:07:25Z