Forum Discussion

cpowers's avatar
cpowers
Regular Visitor
9 years ago
Solved

Multiple Relationships

Hello All,   I'm sure this question has been posed before but I'm new to Power Bi and don't know exactly how to ask.   I have an Opportunities table that references Users, from User table, for mu...
  • BetterCallFrank's avatar
    BetterCallFrank
    9 years ago

    Hi cpowers

     

    please create the additional relationships and leave them inactive.

     

    Then create measures like this:

     

    Admin User = CALCULATE(
  VALUES(Users[Full Name]),
  USERELATIONSHIP(Opportunities[Admin User ID], Users[User ID])
)

     

    PS: see https://www.sqlbi.com/articles/userelationship-in-calculated-columns/ for other concepts around this topic and additional patterns/solutions for your question - maybe consider the VLOOKUP solution here

     

    HTH,

    Frank

BetterCallFrank's avatar
BetterCallFrank
Icon for Resolver IV rankResolver IV
9 years ago

Hi cpowers

 

please create the additional relationships and leave them inactive.

 

Then create measures like this:

 

Admin User = CALCULATE(
  VALUES(Users[Full Name]),
  USERELATIONSHIP(Opportunities[Admin User ID], Users[User ID])
)

 

PS: see https://www.sqlbi.com/articles/userelationship-in-calculated-columns/ for other concepts around this topic and additional patterns/solutions for your question - maybe consider the VLOOKUP solution here

 

HTH,

Frank