Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am currently trying out a way to avoid using double tables in my datamodel. So i have been messing arround with inactieve relationships but i cant seem to make it work. I have tried using the related and relationship functions in dax but no succes so far. These are new functions for me so i am not sure how they are properly used.
What i would like to acomplish is the following: As an example i have two tables a name table(customer details) and test table. In the test table i have 2 customer codes, 1 is the billing information and the other is the normal information. But they can also be the same code, however in some situations the codes differs. Now for those i want to be able to see the adress, city and name using the code2 in the test table (the inactive relation). So in a table when i select code2 i would like to display the information for the code 2 not code1. The data is not summed or counted or anything. Its just the information i need. I would like to avoid creating two name tables and duplicating my data.
Thx in advance greetings, Robin
Solved! Go to Solution.
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
Proud to be a Super User!
@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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |