title: How do I calculate/count rows in a table
body: <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Location</th>
  <th>data/time</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>New york</td>
  <td>22-02-28 22:00:00</td>
  </tr>
  <tr>
  <td>New york</td>
  <td>22-02-27 21:00:00</td>
  </tr>
  <tr>
  <td>New york</td>
  <td>22-02-26 20:00:00</td>
  </tr>
  <tr>
  <td>New york</td>
  <td>22-02-25 19:00:00</td>
  </tr>
  <tr>
  <td>Chicago</td>
  <td>22-02-28 22:00:00</td>
  </tr>
  <tr>
  <td>Chicago</td>
  <td>22-02-27 22:00:00</td>
  </tr>
  <tr>
  <td>Chicago</td>
  <td>22-02-26 22:00:00</td>
  </tr>
  <tr>
  <td>Chicago</td>
  <td>22-02-25 22:00:00</td>
  </tr>
  <tr>
  <td>Paris</td>
  <td>22-02-25 22:00:00</td>
  </tr>
  <tr>
  <td>Paris</td>
  <td>22-02-25 22:00:00</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Q1 How can I count how many rows in date/time I have.
  So far using <code>Count = Count(Table1[DateTime])</code> seems to be counting all rows in this example would 10. What Im looking for would display, NY 4, Chicago 4, Paris 2.</p>
  <p>Q2. How would I calculate a percentage. So far Ive tried <code>(96 - COUNT('Table1'[DateTime]))/96</code> but that brings back the wrong values. (96 represents the number of entries I'm expecting and Im trying to calculate how many entries are missing in the table)</p>
  <p>Thanks in advance</p>