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 u...
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.