USERELATIONSHIP issues

[Anonymous]

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

[MFelix · Accepted 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