title: DAX: calculating the sum/count for each group
body: <p><a href="https://i.stack.imgur.com/7vnrS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7vnrS.png" alt="enter image description here"></a></p>
  
  <p>Hi, I want to use the DAX to realize the following function shown in Result:</p>
  
  <p>The formula is like SUM(Lead Time） Per “Order Ref"/Count(Order Ref) </p>
  
  <p>Here is an example:</p>
  
  <p>For Ref 1: it should be (3+3+3)/3
  For Ref 2: should be (2+2)/2</p>
  
  <p>How can I realize it? Many thanks in advance.</p>