title: How to do a group by on a count in powerbi
body: <p>If I have a table called Data with the following rows:</p>
  
  <pre><code>UserID  action
  1       went shopping
  1       went shopping
  2       cut grass
  3       work
  3       work
  </code></pre>
  
  <p>I'm simply trying to create a bar chart that tells me how many actions each user took. When I select the bar chart and select the table's <code>UserID</code> column its counting basically the total row count and not the occurrences. </p>
  
  <p>I'm looking for something like</p>
  
  <pre><code>1  2
  2  1
  3  2
  </code></pre>
  
  <p>What am I doing wrong here? </p>