title: Dependency error while using LOOKUPVALUE() in Power BI with two foreign keys
body: <p>I am stuck with a very simple (yet frustrating problem). I have table1 with the following columns :</p>
  
  <pre><code>id1  id2   title1                  title2
  ------------------------------------------------
   1    2    A great headline        ERROR
   1    3    A great headline        ERROR
  </code></pre>
  
  <p>title1 &amp; title2 are column populated from table2 with the LOOKUPVALUE() function. table2 looks like this :</p>
  
  <pre><code>id   title
  --------------------------
   1   A great headline
   2   Another great headline
   3   A third great headline
  </code></pre>
  
  <p>I've put a many-to-one relationship between table1[id1] and table2[id] and managed to get values for table1[title1] using this formula : </p>
  
  <pre><code>LOOKUPVALUE(table2[title]; table2[id]; table1[id1])
  </code></pre>
  
  <p>However, when I try to populate table1[title2], I get a circular dependency error.</p>
  
  <p>I tried both those functions :</p>
  
  <pre><code>LOOKUPVALUE(table2[title]; table2[id]; table1[id2]) -&gt; Look id2 into id and return title
  
  LOOKUPVALUE(table1[title1]; table1[id1]; table1[id2]) -&gt; Look id2 into id1 and return title1
  </code></pre>
  
  <p>Could someone suggest a work-around for this problem?</p>
  
  <p>Many thanks.</p>