Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
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])
I thought it did. I changed the drop down to DAX guide but I thought it was the same model
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])
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
71 | |
37 | |
21 | |
19 | |
15 |
User | Count |
---|---|
125 | |
37 | |
29 | |
29 | |
24 |