cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ilcaa72 Member
Member

How to make a relationship, no distinct columns

hello,

 

i have 2 tables.  Table 1 = 764 rows, Table2=9384 rows.

 

i keep getting error messages saying " relationship cannot be created, because 1 of the columns must have unqiue values"  through 1 does have have unique values...

 

any otpions?  thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Moscuba Member
Member

Re: How to make a relationship, no distinct columns

If there is even one of the values repeated it is not Unique.

 

Manually set the relkationship:

Go to the Schema View 

Click on Manage Relationships

Select the table with Many data points (top section), highlight the column to link

Select the table  with unique values (bottom Section), highlight the column to link

Cardinality: Many to one

Cross Filter direction: Single

 

If that doesn't work you may have to make a table to go between them that has nothing in it but the unique values. 

View solution in original post

2 REPLIES 2
Moscuba Member
Member

Re: How to make a relationship, no distinct columns

If there is even one of the values repeated it is not Unique.

 

Manually set the relkationship:

Go to the Schema View 

Click on Manage Relationships

Select the table with Many data points (top section), highlight the column to link

Select the table  with unique values (bottom Section), highlight the column to link

Cardinality: Many to one

Cross Filter direction: Single

 

If that doesn't work you may have to make a table to go between them that has nothing in it but the unique values. 

View solution in original post

VSchepens Regular Visitor
Regular Visitor

Re: How to make a relationship, no distinct columns

Hi @ilcaa72,

 

Your table with unique values must not include a blank row.

Can you check whether this is the case?

 

If you create a table with twice the key in the columns, once as text and once as count, you can check whether certain values appear twice or if your table includes blank rows.

 

Regards,

 

Valérie

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 390 members 3,582 guests
Please welcome our newest community members: