Forum Discussion

LauritzBL's avatar
LauritzBL
New Member
8 years ago
Solved

Problem with creating a satisfactory relationship model

Hello   I work at a medium-sized company as a data scientist. We began to work with Power BI a couple of months back, and are therefore quite new to the game. We are currently working on creating a...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

LauritzBL,

What error message do you get when you create relationship between Packages <-> contact, Packages <-> Recurring Gifts?

In your scenario, you can set cross filter direction of relationship between Gifts and Recurring Gifts from “Both” to “Single” , that way, you should be allowed to make the relationship between the Packages and Recurring Gifts active.

Regards,
Lydia

noyrotbart's avatar
noyrotbart
Frequent Visitor
8 years ago

Hey. My name is Noy and I'm the head of the department in this organization.

Thanks for the input!

An initial problem that was not conveyed in the first post concerns the connection between contact and gifts.

To make it clear, contacts can give single gifts, or regular gifts (once a month), which spawn a chain of gifts.

We would be very happy to have all connections active, but this seem to be not possible.

Is there a workaround to this scenario?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    noyrotbart,

    Could you please post the full error message in Power BI Desktop?

    Regards,
    Lydia

    • noyrotbart's avatar
      noyrotbart
      Frequent Visitor
      8 years ago

      Sure:

      "You can't create a direct active relationship between Gifts and contact because an active set of indirect relationships already exists between these tables. To make this relationship active, set the Cross filter direction to "single", delete, or deactivate any of the indirect relationships first".

      (At this point I also note that one can't copy the errors :))