Forum Discussion

Ciria's avatar
Ciria
Advocate III
9 years ago

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...
Need Help
Tips and Tricks
Ciria's avatar
Ciria
Advocate III
9 years ago

Dears

 

Just checking my MasterFile, I found out we have some items without Family assigned (they appear blank)

 

¿Could this be the reason?:smileyembarrassed:

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

  • Ciria's avatar
    Ciria
    Advocate III
    9 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Ciria,

       

      Can you share some sample data? I will try to build relationship on it and share the updated sample.

       

      Regards,

      Xiaoxin Sheng