Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 multiple fields (Owner, Pursuit Leader, Admin User). I created the relationship between Opportunities Owner ID and User ID. This allows me to show Opportunity values based on the Full Name of the User Table. However, I also need to be able to show the Pursuit Leader and Admin User of those Opportunities.
I am aware that you can only have one active relationship. How can I show Owner, Pursuit Leader, and Admin User names all at the same time with only the single relationship.
Thank you for your help!
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |