title: Is there a way to filter a table based on criteria from another table in Power BI using DAX?
body: <p>So, I have two tables, Scores and Accounts.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID</th>
  <th>Score</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>120</td>
  </tr>
  <tr>
  <td>2</td>
  <td>150</td>
  </tr>
  <tr>
  <td>3</td>
  <td>100</td>
  </tr>
  </tbody>
  </table>
  </div><div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID</th>
  <th>Account</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>Account 1</td>
  </tr>
  <tr>
  <td>2</td>
  <td>Account 2</td>
  </tr>
  <tr>
  <td>3</td>
  <td>Account 3</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I also have 4 measures that calculate the quartile percentile for all of the scores in the Scores table. I was wondering if it was possible to have a measure that concatenates the accounts into one line if their score is, for example, greater than the Quartile 1 measure. For example, if quartile 1 is 110, then I want a measure that would give me &quot;Account 1, Account 2&quot;. Is this possible?</p>