Relationships in Matrix

[Anonymous]

Hi,

I have the following relationships and I would like to put the data in a Matrix. I want to show the IDs of the SWR Module that are allocated to each c_CustomerID in STR A-Sample.

I'm using the following visual settings, but it gives an error.

[v-robertq-msft · Accepted solution]

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.

[PaulDBrown]

@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)

[Anonymous]

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

[PaulDBrown]

@Anonymous 

You should add these relationships and then use the fields from the Dim tables in your visuals:

[Anonymous]

Hi Paul, what you mention does not have the same type of data. Although the names are similar there is no relationship.

[PaulDBrown]

@Anonymous 

The customer fields are different?

If the customer sets from both tables are different, what's the point of having having a customer set which isn't related to the other field in the same matrix? What is your objective?

can you share a sample PBIX file hiding confidential data? 

[Pragati11]

Hi @Anonymous ,

Your query is incomplete as it doesn't mention what error you are getting.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Thanks,

Pragati

[amitchandak]

@Anonymous , Try if treatas can help

https://docs.microsoft.com/en-us/dax/treatas-function

[Anonymous]

Sorry, I don't know how and where to use that function