Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Relationships in Matrix

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.

 

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    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.

9 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        PaulDBrown
        Community Champion
        5 years ago

        Anonymous 

         

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

         

  • v-robertq-msft's avatar
    v-robertq-msft
    Community Support
    5 years ago

    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.