title: Azure analytics query row count
body: <p>I would like to count the number of rows in my query. Is this possible in azure analytics query language? And how should I do this?</p>
  
  <pre><code>requests
  | where name == "MyName"
  | summarize by tostring(customDimensions.myCustomProperty)
  </code></pre>
  
  <p>Result:
      customDimensions_myCustomProperty
      item1
      item2
      item3
      item4</p>
  
  <p>In SQL I would just do this:</p>
  
  <pre><code>select count(distinct(customDimensions.myCustomProperty)
  from requests
  where name == "MyName"
  </code></pre>