Forum Discussion
Cannot create active relationship between two tables
A few questions then:
1) What is the data source you're using direct query on? If this is direct query against SSAS or a power bi dataset then what you're trying to do won't work. (Can try and explain more if that's the case).
2) If the direct query source is plain sql relationsal database then I don't understand the need for the index table? Can you explain?
3) How have you created the index table? Eg is it a calculated table or in power query.
There are no duplicates in the UserId so I think it should be 1:1. Even so I tried 1:* and I get this with both single and both as cross filter directions.
Hi Fourthsky ,
In addition to bcdobbs's reply, here I have a test by direct query for Power BI Dataset or AS.
In my sample "Emp ID" and "User" tables are enter tables, and my data model is in Mixed mode.
Here I can create a relationship between "Emp ID" and "User". Please check whether there is a relationship between "TicketLabourEntries" and "User" table in Manage Relationship.
Or you can try to create inactive relationships and then create measures by USERELATIONSHIPS().
If this reply still couldn't help you solve your issue, please share more details about your storage mode, data source and so on.
Best Regards.