Forum Discussion
Relationships in Matrix
Hi, Anonymous
According to your description and sample picture, if you want to make the Matrix display the correct value, you can try to build a relationship on these tables directly and give them a “Both” filter relationship, like this:
If it’s not enabled, you can try to disable relationships to other tables if it’s possible.
If you still have a problem, you can post the sample pbix file(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
I suggest you set up your model like this (and get rid of the many-to-many relationship - delete both relationships with the red X ). Create dimension tables for both "Customer ID" and "In-Links at depth" with unique values and join in one-to-many relationships with the tables containing the corrsponding fields.
Also change the direction in the relationships from SYR and SWR modules to SYR Module Satis.. to single direction
Then use the unique fields from the dim tables to set up your visuals (or the ID fields from the SYR and SWR modules if you need them)
Thank you for your help,
I've created the following relationships as you suggested
And when I try to put the following on a Matrix it gives me an error
Anonymous
You should add these relationships and then use the fields from the Dim tables in your visuals:
Hi Paul, what you mention does not have the same type of data. Although the names are similar there is no relationship.