Brining in another columns from related table

[stribor45]

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

[stribor45]

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

[erickeu]

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

[stribor45]

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

[erickeu]

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]

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

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 

 or giving it a kudo 

Thanks!