Forum Discussion
Helper IIIBuilding a Table Visual - error "Can't determine relationships between the fields"
I think I understand the nature of the problem....
The Deals can have more than one Company.. and the Deals can have more than one Status.
When trying to put these together liek below
Deal, Company(s), Status(es)
Power BI does not know how to list these in one Table.. in that for every Deal -> company relationship does it go and get every Deal-Status combination.. the Status and Company while related to a single Deal ... there is no relationship between the Company and Status... showing that in a single table does not make logical sense...
Helper IIII think I understand the nature of the problem....
The Deals can have more than one Company.. and the Deals can have more than one Status.
When trying to put these together liek below
Deal, Company(s), Status(es)
Power BI does not know how to list these in one Table.. in that for every Deal -> company relationship does it go and get every Deal-Status combination.. the Status and Company while related to a single Deal ... there is no relationship between the Company and Status... showing that in a single table does not make logical sense...
Community SupportHi Ray_Brosius
Yes, I think you understand it correctly. If you want to have a meaningful pair of company and status values for each Deal, it would be better to record this in the fact table when each Deal happens or changes.
Regards,
Community Support Team _ Jing