title: DAX : Using USERELATIONSHIP and getting a circular dependency detected error
body: <p>i have 2 tables which have 2 relationships based on 2 dates :
  The &quot;daily_valus&quot; table have several products per date which (date) is connected to the weeklies table on the 2 dates (date fin adjusted &amp; date début adjusted). The &quot;date début adjusted&quot; is the active one.</p>
  <p><a href="https://i.stack.imgur.com/L7hDO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/L7hDO.png" alt="enter image description here" /></a></p>
  <p>I have the following formula in a new column (ctRow) of the weeklies table :</p>
  <pre><code>= calculate( COUNTROWS(daily_valus); USERELATIONSHIP(daily_valus[Détail.Date];weeklies[date fin adjusted]))
  </code></pre>
  <p>The formula works and is getting the right number of rows.</p>
  <p>However, I have another add. column and i'm just refererencing the ctRow column :</p>
  <pre><code>= weeklies[ctRow]
  </code></pre>
  <p>then i got that error below.</p>
  <p><a href="https://i.stack.imgur.com/n9iHi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/n9iHi.png" alt="enter image description here" /></a></p>
  <p>Does anyone knows why ?</p>