title: Power BI - count grouped values with condition
body: <p>I'm new to Power BI and struggling to work out the following.In excel i would have used a COUNTIF. I have a table:</p>
  
  <pre><code>+-----+----------+
  | ID  | Status   |
  +-----+----------+
  | 1   | Complete |
  +-----+----------+
  | 2   | Started  |
  +-----+----------+
  | 3   | Started  |
  +-----+----------+
  | 1   | Complete |
  +-----+----------+
  | 1   | Complete |
  +-----+----------+
  </code></pre>
  
  <p>I would like to summarize the data and count the number of <code>complete</code> jobs, grouped by <code>ID</code>. The output i would like is :</p>
  
  <pre><code>+-----+----------+-------+
  |  ID | Status   | Count |
  +-----+----------+-------+
  | 1   | Complete | 3     |
  +-----+----------+-------+
  | 2   | Started  | 1     |
  +-----+----------+-------+
  | 3   | Started  | 1     |
  +-----+----------+-------+
  | 1   | Complete | 3     |
  +-----+----------+-------+
  | 1   | Complete | 3     |
  +-----+----------+-------+
  </code></pre>
  
  <p>Which i would then like to keep only distinct values where the count is greater than 2 (is this possible without the intermediate step above? ). So my final desired result is:</p>
  
  <pre><code>+-----+----------+-------+
  | ID  | Status   | Count |
  +-----+----------+-------+
  | 1   | Complete | 3     |
  +-----+----------+-------+
  </code></pre>
  
  <p>I have tried:</p>
  
  <pre><code> Unique =  COUNTAX(FILTER(Sheet1,(Sheet1[Status] = "Complete" &amp;&amp; (Sheet1[Status] = EARLIER(Sheet1[Status])))),Sheet1[Status])
  </code></pre>
  
  <p>but this gives me a running total and not the count.</p>
  
  <p>What formula do i need to use please?</p>
  
  <p>thanks</p>