Forum Discussion

someonerandom's avatar
someonerandom
Regular Visitor
5 years ago

Data Relationship Error

[ Spoiler ] Hi,   I have 15 SharePoint Online database containing around 5-50 rows of data similiar to the following  Ill call these DataBASE1 to DataBASE15 Name Skill Code (Unique) Skill E...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi, someonerandom 

This problem usually occurs when you try to  use the second active relationship.

Can you show screenshots of all the relationships related to the table "Skills Name Index" and the table "DataBASE2"?

Make sure only one common column to create a  active relationship between two tables. 
You can  try to create an inactive relationship and activate it by creating a new measure through function " userealtionship".

 

If I misunderstand,do you mind create a sample  pbix file and list the expected result clearly, so that we can post detailed solution..

 

Best Regards,
Community Support Team _ Eason