Relationship

Hello,

I am having an issue with relationships in PBI.

I am working with Azure Dev Ops elements, and I have a table of User Stories that contains a column called Parent Work Item ID. Normally, the hierarchy should be Epic => Feature => User Stories, that means that an Epic has several features, and a feature has several User Stories. All of them are linked by the column called Parent Work Item ID.

The problem is that this column can contains different type of parent ID.

I have some User Stories that are not linked to a Feature as parent, but the Epic. When that happens, I have the ID of an EPIC in the Parent Work Item ID column. I have active relationships for Epic and Feature, Feature and User Stories and I would like to also add another relationship between User Stories and Epic. Every time I try to do it, I receive a message like that:

You can’t create a direct active relationship between User Stories and Epics 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.

I can’t disable the relationships I have already (EPIC -> Feature -> User Stories) because I also need them. Do you know a way to solve this problem?