DAX Calculate the sum of cost divide by count of cost

[Anonymous]

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.  

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. 

Appreciate any help.

[amitchandak · Accepted solution]

@Anonymous ,

sumx( values(Table[Work Order]),Quoted Cost = DIVIDE([Planned Cost],[Count of Planned Cost]))

[Anonymous]

Super thanks amit!!