Home › Forums › Power BI › relationship between two tables in power pivot data model Tagged: pivot data model, PowerBI This topic contains 3 replies, has 3 voices, and was last updated by infinitex86 4 months ago. Viewing 4 posts - 1 through 4 (of 4 total) Author Posts July 18, 2018 at 5:50 am #10183 sailajaParticipant Started: 2Replies: 1Total: 3 Is it possible to have over one active relationship between two tables in power pivot data model? August 26, 2018 at 2:38 am #10437 m3tr01dParticipant Started: 0Replies: 17Total: 17 Hi, I’m not a Pro but I don’t think it is possible. If you can explain what your tables looks like, we can see if we can do a modification to your data model 🙂 Most of the time, this situation happen with a Fact table contaning 2-3 different dates (like a Sales table) with a relation to a date table. September 19, 2018 at 12:59 pm #10644 sailajaParticipant Started: 2Replies: 1Total: 3 Hi, Thank For Your Replay September 19, 2018 at 2:32 pm #10647 infinitex86Participant Started: 3Replies: 9Total: 12 I don’t believe there’s a way to have more than 1 *active* relationship, but you can always have an inactive relationship and then specify which relationship you want using the USERELATIONSHIP() function. Documentation can be found here: https://msdn.microsoft.com/en-us/query-bi/dax/userelationship-function-dax Author Posts Viewing 4 posts - 1 through 4 (of 4 total) You must be logged in to reply to this topic.