title: Modify table columns based on filters
body: <p>I have a table like the one below and I would like to modify a column based on a filter criteria I apply using a dropdown menu.</p>
  <p>Filter: clientAAA</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Country</th>
  <th>Sales by all clients</th>
  <th>Sales by clientAAA</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Spain</td>
  <td>30000</td>
  <td>100</td>
  </tr>
  <tr>
  <td>France</td>
  <td>6400</td>
  <td>3000</td>
  </tr>
  <tr>
  <td>Italy</td>
  <td>5000</td>
  <td>50</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>My idea is to have a slicer where I can select a client or a bunch of them and modify the last column of my sales table showing the sales done by the selected client split by countries. Is it doable in powerbi?</p>
  <p>Thanks!</p>