Forum Discussion
How to create relationship between two tables
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 UTC
johnmelbourne 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. 😁
