Forum Discussion
data does not match
Hi, I have a model as uploaded here. https://easyupload.io/t3qpdk When I compare two tables, they do not match. When I tried with even simpler example where there is a list of supplier na...
I have measures calculating scores for each category, incluing Delivery, Quality, Responsiveness and tabularised like below
As I would like to have a table, listing scores per category, first I have created a calculated table like below.
Based on this table, I have tabularised like below
I was expecting that when compared two tables, the score should be matched per supplier. But it does not.
I do see many to many relationship. It is due to supplier list, having the same name but multiple supplier code.
Not sure how I can avoid this many to many relationship.