Unable to create multiple relationships to one field

[Anonymous]

Hi there. I'm very new to Power BI and hope someone can help me with what I'm sure is a basic problem, but one I can't figure out. I am working with five Sharepoint lists: UserInfo, Projects, StatusReports, Issues and Risks (I'm creating a very simple risk/issue/report app).

The UserInfo table has all the User Info pulled from the Sharepoint user list with a unique ID field. Each of the other tables has one at least two user fields (author and modified, for example, as well as some others like Project Manager). I'm therefore trying to create multiple relationships to the ID field in user info from each of the user fields in the other tables. If I try to create two links frmo the same table (e.g. AuthorID to UserInfo.ID and ModifiedID to UserInfo.ID), I get an error telling me to turn off bidirectional cross-filtering (it's set to single for all relationships already). If I try to create relationships from two tables (e.g. from Risks.CreatedID to UserInfo.ID and Issues.CreatedID to UserInfo.ID), I get an error saying it would introduce ambiguity between the tables.

Is there any way to do what I'm seeking? I want to be able to display the project manager's name rather than ID, as well as all the other user fields. Any help greatly appreciated.

[mwegener]

Hi,
you have to load the UserInfo for each Role (Creator, Author, Project Manager, ...)

[Anonymous]

So, basically add a new data source for each user field? Effectively ending up with UserInfo1, UserInfo2, etc. and then define a relationship to each one separately?

[mwegener · Accepted solution]

Yes, but you could multiply via DAX Table

DAX Table:
UserInfo2 = UserInfo

[Anonymous]

That's great, thanks!