title: Using RELATED function in DAX with USERELATIONSHIP
body: <p>I am trying to pull in a field from another table in my BISM model using the "RELATED" function. Since there are many tables that have relationship to the People table, only ONE relationship is active and the rest are inactive. In this case, the relationship is Inactive, and as I understand it I am to use the "USERELATIONSHIP" function to specify the relationship to use. Based on what I found here: <a href="http://connect.microsoft.com/SQLServer/feedback/details/730493/powerpivot-dax-method-related-does-not-work-if-key-is-inactive" rel="noreferrer">http://connect.microsoft.com/SQLServer/feedback/details/730493/powerpivot-dax-method-related-does-not-work-if-key-is-inactive</a> 
  I thought I could do this: </p>
  
  <pre><code>=CALCULATE(RELATED(People[FullName]]),USERELATIONSHIP(Def[OwnerID],People[PersonID]))
  </code></pre>
  
  <p>But I get the error: </p>
  
  <blockquote>
    <p>The column 'People[FullName]' either doesn't exist or doesn't have a relationship to any table available in the current context.</p>
  </blockquote>