title: DAX Compare rows based on column values
body: <p>I am having the following problem and am completely new to DAX, so I don't know how to solve it. Should be pretty easy probably.</p>
  <p>I have a table looking like this and I want to check for several values whethey they match for filter_id</p>
  <pre><code>id  filter_id
  1   5
  1   17
  2   5
  3   5
  3   17
  4   9
  4   17
  5   17
  </code></pre>
  <p>For example, I want to get all ids which contain filter_id 5 and filter_id 17. Since the data is stored in different rows, I cannot compare with and, since one row cannot possibly have both values.
  The result should be</p>
  <pre><code>id 1 and id 3
  </code></pre>
  <p>since only they have both values.</p>
  <p>Thanks a lot for your help!</p>