Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi,
I have these relationships and tables among others and are using direct query.
When I visualize the UsersInCompany table I want to be able to easily display the name of the user.
The first name and last name is in the profile table and I want to create a calculated column called name in my UsersInCompany table. However I can't seem to acess the profile table at all from by DAX expression when I try to create the new column even though I created a relationsship between UserId and UserId.
Here are the tables in question - what am I doing wrong?
@lehmberg Just by looking at your screenshot, relationship between table UsersInCompany and Profile is not active. Dotted line means relationship isn't active. You need to double click dotted line and tick make this relationship active.
I tried that also and it will still not accpt me referencing Profile form my calculated columns.
I was thinking that maybe a better way is to use the the merge queries option in the Query Editor.
I am a newbie so I don't know what the pros and cons of the two possibilities are.
Can anyone enligten me?
What does error message say when it doesn't accept you referecing Porfile table? It should be related to the cardinality of relationships. Please go to "Manage Relationships" and check the relationship. Even using Merge Query, both table must cotains same rows which should be "One to One" relationship.
Regards,
I got it to work, thanks
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.