Forum Discussion
Relationship issue when i have unique values
Hi Experts
Refer to table dimdata and hierarchy both tables have ItemID. I have unique values in Hierarchy table and multiples in dimdata...
When I try and create an 1 to * relationship its telling me I have multiple values in both tables.
https://www.dropbox.com/s/ilpja4jodpl2vei/SampleData_2.pbix?dl=0
4 Replies
- Fowmy
Super User
Anonymous
When you are creating a relationship as one-to-many, the one side of the relationship must have unique values. In your hierarchy table, there are duplicates 3a and 3b. Remove duplicates and it should work.________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂