title: Filter values based on other column in Power BI
body: <p>In Power BI I'm trying to combine and get the unique values of pages in a new table. I need to filter one of the columns, based on a value of another column in that same table. So i want to do something like</p>
  <blockquote>
  <p>FILTER(VALUES('Table1'[URL]), 'Table1'[Correct] = &quot;Yes&quot;</p>
  </blockquote>
  <p>But it's not working, because I can only filter based on calculations, not columns.
  The complete line that I have now and is working is:</p>
  <blockquote>
  <p>All pages = FILTER(
  DISTINCT(UNION(VALUES('Table1'[URL]),VALUES(Table2[Complete URL]),
  VALUES('Table3'[URLs]))), [URL] &lt;&gt; BLANK())</p>
  </blockquote>
  <p>How can I add a filter to one of those tables, based on another column of that table?</p>