Forum Discussion
Inactive relationship get data
Then you should probably use "USERELATIONSHIP" in measure for Code2 values
https://www.sqlbi.com/articles/using-userelationship-in-dax/
https://docs.microsoft.com/en-us/dax/userelationship-function-dax
RCrom ,
Not very clear.
If you need join on two columns. Create key like this and join
key = [code] & " " [name] in both tables and join key.
In case you need to make inactive join active use use relation. Examples
Hey thx for the reply, i do not wish to join on two colums. I would like to use the use relationship method. But the problem is i am not using a sum or count or anything like that. I just want to switch between relationship and see the code2 as primary key instead of the code1.
Currently when i am using code1 as primary key it works great, but for example on a differnt graph i would like code2 to be the primary key.
Thx
Then you should probably use "USERELATIONSHIP" in measure for Code2 values
https://www.sqlbi.com/articles/using-userelationship-in-dax/
https://docs.microsoft.com/en-us/dax/userelationship-function-dax