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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
stribor45
Post Prodigy
Post Prodigy

Brining in another columns from related table

I am trying to bring the Store Name column from the Store table but keep receiving errors that it is not in the current context. I tried to bring this column by using the RELATED function. Can someone assist, please? 

 

Dax Do link

5 REPLIES 5
stribor45
Post Prodigy
Post Prodigy

What I am trying to do is display a few columns from Sales table that will include "storekey" and I also want to pull store name as well well from Store table

in that case you can use the Summarize function  🙂
ex.
SUMMARIZE ( Sales, Sales[Column 1],Sales[Column 2], Stores[Store Name])

 

stribor45
Post Prodigy
Post Prodigy

I thought it did. I changed the drop down to DAX guide but I thought it was the same model

 

stribor45_0-1701085119363.png

 

Not sure what you're trying to test, but in order to bring a RELATED column, you need to iterate the table that is on the many side 🙂 

for example you can do :

ADDCOLUMNS ( Sales, "@MyStoreName", RELATED(Store[Store Name])

 

 

erickeu
Advocate I
Advocate I

Hi @stribor45 the datamodel that you posted here doesn't have the Dim Store 🙂

erickeu_0-1701076698967.png


if this helps, please 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution 

erickeu_5-1701076753936.png

 

 or giving it a kudo 

erickeu_6-1701076753936.png

 


Thanks!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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