Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
lehmberg
Advocate II
Advocate II

how to access column in related table in calculated column using direct query

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? 

 

2016-05-23_1333.png

 

4 REPLIES 4
ankitpatira
Community Champion
Community Champion

@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?

@lehmberg

 

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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.