title: How to count how many times a value appears in a list based on another column in Power BI?
body: <p>I have this sample table</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>City</th>
  <th>Store</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>City1</td>
  <td>STORE1</td>
  </tr>
  <tr>
  <td>City1</td>
  <td>STORE2</td>
  </tr>
  <tr>
  <td>City1</td>
  <td>STORE3</td>
  </tr>
  <tr>
  <td>City2</td>
  <td>STORE4</td>
  </tr>
  <tr>
  <td>City3</td>
  <td>STORE5</td>
  </tr>
  <tr>
  <td>City3</td>
  <td>STORE6</td>
  </tr>
  <tr>
  <td>City3</td>
  <td>STORE7</td>
  </tr>
  <tr>
  <td>City4</td>
  <td>STORE8</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want to show a card that will tell me how many stores are present in the table in a city.
  For example, if I have a slicer and I pick Store1, the card should read 1 of 3 because it's 1 store of a 3 within the same city.</p>
  <p>What's the best way to approach this?</p>