Forum Discussion

Namirza's avatar
Namirza
Frequent Visitor
4 years ago

USERELATIONSHIP function can only use the two columns references participating in relationship.

in this tutorial, Create-reports/desktop-dimensional-model-report ,on creating new measure 

  1. Sales Amount by Due Date = CALCULATE(SUM(Sales[Sales Amount]), USERELATIONSHIP(Sales[DueDateKey],'Date'[DateKey]))
  2. get the error    USERELATIONSHIP function can only use the two columns references participating in relationship.
  3. highly appreciate solution to

3 Replies

  • davehus's avatar
    davehus
    Memorable Member

    Hi Namirza , Have you created an inactive relationship between the two tables in question?

     

    D

    Did I help you today? Please accept my solution and hit the Kudos button.

    • Namirza's avatar
      Namirza
      Frequent Visitor

      yes inactive relationship is created.