Data modeling issue

[VenkatTav]

Hi Team,

I have built a model where my fact has one to many relationship with multiple dimension table as below, I 'm getting a relationship error when i building a report using colums from loan, service code and borrower. 

kindly help me with possible solution in model change or creating relationship using dax

sample report error :

Thanks in advance.

[amitchandak · Accepted solution]

@VenkatTav , you can not use "not summarized" columns from both facts(Many side), take the max of loan number from one of the facts