Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Ciria
Advocate III
Advocate III

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 code.

 

The point is that Master Item has a column named "Family", the purpose of this field is to create a simpler clasification to analyze sales (instead of multiples codes, we wrap them in families for better analysis).

I have created a query with that column, covert to Table, arrange, rename and remove duplicates

 

The "funny" thing is when I try to create a relathionship between the new query "Family" with Commercial Budget, a message telling me is not possible because no "uniques values in any table" appers.

 

How is this possible? Why can't PowerBI recognize the new Query "Family" as single values after removing duplicates?

I could use related but I want a different design...

 

I hope you may help 🙂

 

Regards,

4 REPLIES 4
Ciria
Advocate III
Advocate III

Dears

 

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

 

¿Could this be the reason?Smiley Embarassed

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi @v-shex-msft

 

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors