1 to many relationship not working as expected

[AmiraBedh]

I have the following model :

You can see that the relationship 1 to many between the Fact Journals and the Dim Client based on the Client Id which is inactive since Dim Client is linked to Dim Account and it is an active relationship.

When I try to add in a table visual the Client Id from Fact Journals and the Client Id from Dim Client, I get unexpected result like below :

When I check in my database using LEFT JOIN, I find that the Journals Client Id = fidinc_00000005 from the fact table there is no Client Id in the Dim Client

So why the result is not 

Client Id          Journals Client Id

 NULL             fidinc_00000005

why the values are different ?

[Idrissshatila · Accepted solution]

Hello @AmiraBedh ,

it's because it's in active and it's passing the filter through the dim account then passing through to the fact journal.

[AmiraBedh]

I had a doubt because it is an active just wanted to make sure that my thoughts are not wrong.