Relationships not working as expected...

[Anonymous]

Hi All,

I am getting the error about about no matching columns when I add a column into a Matrix.

I ran a simple test where I have a master with 2 detail tables and have relationships from the master to each detail table.

1. I added one column from the detail A into an empty Matrix Visualization. No issues.

2. I add a column from the second detail table B and get the error about not being able to match the two columns.

If I change the relationships from Master to detailA and detail A to detail B then both detail columns can be added to the Matrix. Basically a daisy chain and not a star type schema that I need.

There must be something I am missing or the Model releationships are not what I expected.

Thanks!

[v-chuncz-msft · Accepted solution]

@Anonymous 

Drag a custom measure to Values and check query with Performance Analyzer.

[amitchandak]

@Anonymous 

If you have this kind of relation. You must have Column from Master C table to have data from both detail table

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490