The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi everyone,
For a report on stock flows I need to have the name of both the "From" location and "To" location. Both these entities are related to the same warehouse location dimension. Power BI only allows only 1 single active relationship:
So I will need to "calculate" the other name manually. (I can't copy the Warehouse table due to RLS role constraints).
I used the following DAX statement to manually force PBI to use the inactive relationship:
NameTo = CALCULATE( VALUES(Warehouse[Name]); USERELATIONSHIP(Warehouse[ID]; Flow[To]) )
The result gives me the same name as the active relationship which I don't want.
Can anyone help me with my statement?
Thanks in advance,
Harm
Solved! Go to Solution.
Hi @Anonymous,
I would not use the relation between both table I would do two columns on your data table with the following syntax:
From name = LOOKUPVALUE(Warehouse[Name], Warehouse[ID] , Flow[From]) To name = LOOKUPVALUE(Warehouse[Name], Warehouse[ID] , Flow[To])
If you want to use the column with the user relationship you need to make the column on the Flow table and not on the wharehouse table as you have that's why you have the same name always.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous,
I would not use the relation between both table I would do two columns on your data table with the following syntax:
From name = LOOKUPVALUE(Warehouse[Name], Warehouse[ID] , Flow[From]) To name = LOOKUPVALUE(Warehouse[Name], Warehouse[ID] , Flow[To])
If you want to use the column with the user relationship you need to make the column on the Flow table and not on the wharehouse table as you have that's why you have the same name always.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
107 | |
75 | |
61 |
User | Count |
---|---|
276 | |
129 | |
122 | |
100 | |
88 |