Model is Enforcing Inner Join

[HeirsPowerBi]

Hello Guys

I have a data model like this

But for some reason when i bring in columns from policies and endorsements to a table visual it appears like an inner join instead of showing me all the policies it only shows the ones that have endorsements......then when i add a column from installments to it i get the error that it cannot determine relationhip between two fields.

I cannot figure out why this is because i want to see all policies....Empty values for endorsement where there is none and same for installment, Please help

[amitchandak · Accepted solution]

@HeirsPowerBi , You can not have not-summarized column from two many side tables

so column from endorsements  or installments need to have some aggregation

[HeirsPowerBi]

I may have been too quick to mark as solution.

So i have removed the column from installments and what i get is still an Inner Join of policies and endorsements, instead of a Left Join

Any ideas