Forum Discussion

VenkatTav's avatar
VenkatTav
Frequent Visitor
3 years ago
Solved

Data modeling issue

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.

 

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

1 Reply

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