title: USERELATIONSHIP function can only use the two columns references participating in relationship
body: <p>I am trying to create measures which use different date columns within the same table. I have an order date and a shipment date. I want to compare how many orders are received on each week day with the amount of orders that are shipped on each weekday. I have a separate DATE table and I am using the 'USERELATIONSHIP' function in DAX. This is the main orders table:</p>
  <p><a href="https://i.stack.imgur.com/IiW5C.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IiW5C.png" alt="enter image description here" /></a></p>
  <p>As you can see, there are two columns with order date and ship date. This is the DATE table:</p>
  <p><a href="https://i.stack.imgur.com/bUhCz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bUhCz.png" alt="enter image description here" /></a></p>
  <p>The relationship between these tables is by default, between the 'Order Date' column and 'DATE[Date]' table/column. This is the formula I have where I use the USERELATIONSHIP function:</p>
  <pre><code>Shipped-volumes = CALCULATE(COUNTROWS('DIM-Order'), USERELATIONSHIP('DIM-Order'[Ship Date], 'DATE'[Date]))
  </code></pre>
  <p>I am receiving the error message:</p>
  <p>'USERELATIONSHIP function can only use the two columns references participating in relationship.'</p>
  <p>Any ideas why?</p>