title: List of non-filtered values with a filtered value
body: <p>I'm trying to put together a reference tool in Power BI where a user can filter data containing property visit information by various clients:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Client_ID</th>
  <th>Property_ID</th>
  <th>Date_Start</th>
  <th>Date_End</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>client_1</td>
  <td>1</td>
  <td>1/1/2019</td>
  <td>1/7/2019</td>
  </tr>
  <tr>
  <td>client_2</td>
  <td>1</td>
  <td>1/5/2019</td>
  <td>1/12/2019</td>
  </tr>
  <tr>
  <td>client_3</td>
  <td>1</td>
  <td>1/2/2019</td>
  <td>1/14/2019</td>
  </tr>
  <tr>
  <td>client_1</td>
  <td>2</td>
  <td>2/1/2019</td>
  <td>2/5/2019</td>
  </tr>
  <tr>
  <td>client_3</td>
  <td>2</td>
  <td>2/2/2019</td>
  <td>2/8/2019</td>
  </tr>
  <tr>
  <td>client_4</td>
  <td>2</td>
  <td>2/4/2019</td>
  <td>2/12/2019</td>
  </tr>
  <tr>
  <td>client_2</td>
  <td>3</td>
  <td>3/3/2019</td>
  <td>3/10/2019</td>
  </tr>
  <tr>
  <td>client_3</td>
  <td>3</td>
  <td>3/9/2019</td>
  <td>3/13/2019</td>
  </tr>
  <tr>
  <td>client_4</td>
  <td>3</td>
  <td>3/12/2019</td>
  <td>3/25/2019</td>
  </tr>
  <tr>
  <td>client_1</td>
  <td>4</td>
  <td>4/5/2019</td>
  <td>4/10/2019</td>
  </tr>
  <tr>
  <td>client_2</td>
  <td>4</td>
  <td>4/6/2019</td>
  <td>4/9/2019</td>
  </tr>
  <tr>
  <td>client_3</td>
  <td>4</td>
  <td>4/12/2019</td>
  <td>4/15/2019</td>
  </tr>
  </tbody>
  </table>
  </div>
  <ol>
  <li>A user is be able to select one client from a slicer and generate a list of all their property stays (e.g., client_1 property visits):</li>
  </ol>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Slicer:</th>
  <th>client_1</th>
  <th></th>
  <th></th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>Client_ID</td>
  <td>Property_ID</td>
  <td>Date_Start</td>
  <td>Date_End</td>
  </tr>
  <tr>
  <td>client_1</td>
  <td>1</td>
  <td>1/1/2019</td>
  <td>1/7/2019</td>
  </tr>
  <tr>
  <td></td>
  <td>2</td>
  <td>2/1/2019</td>
  <td>2/5/2019</td>
  </tr>
  <tr>
  <td></td>
  <td>4</td>
  <td>4/5/2019</td>
  <td>4/10/2019</td>
  </tr>
  </tbody>
  </table>
  </div>
  <ol start="2">
  <li>Here's it he problematic part: User should be able to generate a list of all other clients that stayed at the same properties client_1 stayed at:</li>
  </ol>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Slicer:</th>
  <th>client_1</th>
  <th></th>
  <th></th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>Property_ID</td>
  <td>Client_ID</td>
  <td>Date_Start</td>
  <td>Date_End</td>
  </tr>
  <tr>
  <td>1</td>
  <td>client_1</td>
  <td>1/1/2019</td>
  <td>1/7/2019</td>
  </tr>
  <tr>
  <td>1</td>
  <td>client_2</td>
  <td>1/5/2019</td>
  <td>1/12/2019</td>
  </tr>
  <tr>
  <td>1</td>
  <td>client_3</td>
  <td>1/2/2019</td>
  <td>1/14/2019</td>
  </tr>
  <tr>
  <td>2</td>
  <td>client_1</td>
  <td>2/1/2019</td>
  <td>2/5/2019</td>
  </tr>
  <tr>
  <td>2</td>
  <td>client_3</td>
  <td>2/2/2019</td>
  <td>2/8/2019</td>
  </tr>
  <tr>
  <td>2</td>
  <td>client_4</td>
  <td>2/8/2019</td>
  <td>2/12/2019</td>
  </tr>
  <tr>
  <td>4</td>
  <td>client_1</td>
  <td>4/5/2019</td>
  <td>4/10/2019</td>
  </tr>
  <tr>
  <td>4</td>
  <td>client_2</td>
  <td>4/6/2019</td>
  <td>4/9/2019</td>
  </tr>
  <tr>
  <td>4</td>
  <td>client_3</td>
  <td>4/12/2019</td>
  <td>4/15/2019</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I am able to generate a list of all relevant properties where client_1 stayed at via the selected &quot;client_1&quot; filter in the slicer, however that filtering also flows down to all other Client_IDs. So in the end I end up just having the same table as in Step 1 above, with all other clients filtered out.  Is there a way to remove the filter context from the &quot;Client_ID&quot; field so only the Property_IDs are filtered to display only the ones were &quot;client_1&quot; stayed?</p>
  <p>Real data contains duplicate &quot;Client_ID&quot; values as some clients may have stayed at same property more than once during the period, so that presented an extra challenge when trying to reference all unfiltered values in DAX.</p>
  <p>Ultimate goal is to list all clients that stayed at same properties as client_1 during the same time period:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Slicer:</th>
  <th>client_1</th>
  <th></th>
  <th></th>
  <th></th>
  <th></th>
  <th></th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Client_ID</td>
  <td>Property_ID</td>
  <td>Date_Start</td>
  <td>Date_End</td>
  <td>Client_ID</td>
  <td>Date_Start</td>
  <td>Date_End</td>
  </tr>
  <tr>
  <td>client_1</td>
  <td>1</td>
  <td>1/1/2019</td>
  <td>1/7/2019</td>
  <td>client_2</td>
  <td>1/5/2019</td>
  <td>1/12/2019</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  <td>client_3</td>
  <td>1/2/2019</td>
  <td>1/14/2019</td>
  </tr>
  <tr>
  <td></td>
  <td>2</td>
  <td>2/1/2019</td>
  <td>2/5/2019</td>
  <td>client_3</td>
  <td>2/2/2019</td>
  <td>2/8/2019</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  <td>client_4</td>
  <td>2/8/2019</td>
  <td>2/12/2019</td>
  </tr>
  <tr>
  <td></td>
  <td>4</td>
  <td>4/5/2019</td>
  <td>4/10/2019</td>
  <td>client_2</td>
  <td>4/6/2019</td>
  <td>4/9/2019</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Thanks!</p>