Forum Discussion
How to create relationship between two tables
Hi,
Sorry, I read your requirement incorrectly.
The original poster is partly correct, join both tables on Model. I assume you will have a many to many relationship. This will create a many to many realtionship but that will be ok. Make sure cross filter direction is set to both.
Then create a reference to the Problems table.
Remove all columns except the problem column.
Remove duplicates.
Join the new Problem lookup (slicer / dimension) table to the other problem table on Problem. This will be a one-many relation. It will now slice both.
See images
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
Hi thanks for showing the step, however, i found the result in value is come out incorrectly. I put model/ problem and value in a table but the value is not matching the raw data.
You need to relate both tables using the model column.
That will create a many to many relationship.
In the relationship, make sure the cross filter direction between orders and problems is set to BOTH.
Then create a reference to the problem table, remove all column except but the problem column, then make a relationship between problem in the slicer to problem in the Problems table.
Here is the video: https://www.youtube.com/watch?v=Vq9kXU6am4Q
Here is the pbix: URL https://tmpfiles.org/dl/932942/jointwotables.pbix
Filename jointwotables.pbix
Size 26.82 KB
Expires at 2023-02-13 10:59 UTC
Filename jointwotables.pbix
Size 26.82 KB
URL https://tmpfiles.org/dl/932942/jointwotables.pbix
Expires at 2023-02-13 10:59 UTCjohnmelbourne Dude, you took the time to post 2 videos on YT with all the details on how to solve the problem. You are a legend!
Much respect. 👍👏Thanks ! A comment 2 years after the work from a visitor is still valued. Cheers. 😁
