title: PowerBI: Advanced filtering using data modelling to create dependent dropdowns
body: <p>I have created a <strong>dimension table filter</strong> which is modelled from 2 tables</p>
  <p><a href="https://i.stack.imgur.com/2biXV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2biXV.png" alt="enter image description here" /></a></p>
  <p>Query for someone who has the same problem in the future -</p>
  <pre><code>calcProjectNameFilter = DISTINCT(
  UNION(
  VALUES('Vani_Trends actual'[Project Name]),
  VALUES('Vani_Trends2 - planned'[Project Name])
  )
  )
  </code></pre>
  <p>Now I want to create another filter- phase name but it should be dependent on the selected project name. My attempt was to do something like -</p>
  <pre><code>calcProjectNameFilter = CALCULATETABLE( DISTINCT(
  UNION(
  VALUES('Vani_Trends actual'[Project Name]),
  VALUES('Vani_Trends2 - planned'[Project Name])
  ),
  ALLSELECTED(calcProjectNameFilter)
  ))
  </code></pre>
  <p>but that didn't work. Can anybody help me with creating dependent dropdowns using data modelling?</p>