Forum Discussion
Relationship Difficulty - Message with multiple values Found
Dears I am creating a PowerBI file with a few tables directly connected with our system. Basically I have Commercial Budget (many) and Item Master (one). Both are linked by using the item co...
Hi Ciria,
>>Just checking my MasterFile, I found out we have some items without Family assigned (they appear blank)
Yes, multiple blank value will cause the issue.
In my opinion, you can remove these blank value at power query or create a new table with distinct column value and add the relationship between new table and original tables.
Regards,
Xiaoxin Sheng
Hi Anonymous
I have created this new column:
Column = CALCULATETABLE(DISTINCT(vSP_ArticulosAll[Family]))
The following message is returned: A table with multiple values was supplied where a single value was expected.
Awaiting for your support.
Hi Ciria,
Can you share some sample data? I will try to build relationship on it and share the updated sample.
Regards,
Xiaoxin Sheng