Forum Discussion
VenkatTav
3 years agoFrequent Visitor
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
- amitchandakSuper User
VenkatTav , you can not use "not summarized" columns from both facts(Many side), take the max of loan number from one of the facts