table/matrix don't show all data - inner join instead of left join (column order changes everything

[Csc1]

Hello,
I have strange issue. I have two tables, lets say Fact and Dim:

I would like to show all data for ID from facts even if Dim doesn't have data for specific ID (ID in example: 39779):

ID and Info1 comes from Fact, Manufacturer from Dim. When I change order of column data for Info1 are dissapearing, why ? There is no ID 39779 in Dim intentionally:

Why info1 is blank now ? Dim needs to have multi rows for 1 ID because sometimes I have more than 1 manufacturer for specific ID. It is not first time when i encountered this kind of missunderstood. Thanks in advance for help.

pbix on wetransfer:
https://we.tl/t-yvAbyIaogL

[v-jingzhang]

Hi @Csc1 

Based on my observation and test, it seems when the adjacent columns are from the same table, they filter each other by the relationship in their based table. But when another column from another table sits between them, it would be that ID filters Manufacturer, then Manufacturer filters Info1. ID would not filter Info1 directly.

I hoped to find some documentation explaining how this filter works but unfornately I haven't found anything that can clarify the logic behind it. It's interesting and mysterious...

Best Regards,
Community Support Team _ Jing

[CNENFRNL]

It's absolutely strange if there were no strange issues popping up with a *:* relationship + bilateral filtering.

Normalize your data model to star schema unless you are a seasoned expert of data modeling.

[Csc1]

What if i can't because on 'Dim" (let's skip the name of table, i know its not dim 🙂 ) i have 2 Manufacturer for one id in fact table and i have to show both ?