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...
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 :))