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

[Namirza]

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

[davehus]

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]

yes inactive relationship is created.

[davehus]

Hi @Namirza ,

Can you reverse the lookup. DateKey>SalesDueDateKey