title: Create single slicer for multiple similar columns in Power BI
body: <p>In Power BI I have an inventory with multiple possible owners for each product.</p>
  <p><strong>Example data:</strong></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Product</th>
  <th>Primary Owner</th>
  <th>Backup Owner</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Widget 1</td>
  <td>Frank</td>
  <td>Sally</td>
  </tr>
  <tr>
  <td>Widget 2</td>
  <td>Sally</td>
  <td>John</td>
  </tr>
  <tr>
  <td>Widget 3</td>
  <td>John</td>
  <td></td>
  </tr>
  <tr>
  <td>Widget 4</td>
  <td>Frank</td>
  <td>Anna</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p><strong>Desired result:</strong> to display the full inventory in a table, and provide a slicer that users can filter the table with. The slicer would be a list of all owners (both primary and backup), and when a user is selected the table would display any row where that user is present (whether they are present in the Primary Owner or Backup Owner field.</p>
  <p>With the above example, if you were to filter by John you would see Widget 2 and Widget 3, whereas filtering by Sally would show you Widget 1 and Widget 2.</p>
  <p><strong>Failed attempts:</strong> Using two distinct slicers does not work for this, as it will hide data in the other column. If John were to filter to himself as Primary Owner, he would then no longer see data for Widget 2 where he is the Secondary Owner. Concatenating the Primary and Secondary together into a joined column also does not work, because I would get items like Frank|Sally or Sally|John and the combined data does not make sense for the user as an option in the Slicer.</p>
  <p>Finally I tried creating a separate table that contains the combined list of all Primary and Secondary Owners into a single column, then relating it to the main table, however I cannot have two active relationships at once. I know Measures have access to inactive relationships through Calculate, but I don't know how (or if it is even possible) to create a slicer from that.</p>