title: Power BI - how can i count the occurrences of a value in a column?
body: <p>I have researched this but not been able to get it working correctly.  I am new to Power BI. In the image (i censored user id's) you can see I highlighted order 0625140 because it should total to 3.  I've tried calculated column</p>
  <pre><code>Totals = CALCULATE( COUNT('Billing KPIs'[index])
  , ALLEXCEPT('Billing KPIs', 'Billing KPIs'[order_id])) 
  and quick measures and custom measure .
  
  Totals =
     SUMX(
        VALUES(Data[User]), 
        CALCULATE(COUNT(Data[Group]))
     ) Based on previous posts but nothing has worked yet.  Please advise and thank you for your time.[Image of Data table][1]
  </code></pre>
  <p><a href="https://i.stack.imgur.com/e78kQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/e78kQ.png" alt="enter image description here" /></a></p>