Forum Discussion

AndyM2023's avatar
AndyM2023
New Member
3 years ago

Get text values to display using an inactive relationship

Hello   I'm very new to Power Bi and was wondering if anyone could help with a query I have around table relationships.   So I have three tables:   CONTACT   OPPORTUNITY      USER Con...
Need Help
rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

Hi AndyM2023 - as per my understanding , you can create measure in the Opportunity table to fetch the User Email from the User table.

Owner Email =
CALCULATE(
MAX(User[User Email]),
USERELATIONSHIP(Opportunity[Opportunity Owner ID], User[User ID])
)

 

it works and able to pull in the User Email for each opportunity owner, even with an inactive relationship.

 

Hope it helps

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!