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

relationship problem

Hi all

I have trouble with relationships. Hope someone can help with this issue.

 

I have two lookup tables:

1.Product groups, product names

2.Currency, currency classification

 

and I also have 2 data tables. I have connected my data tables to the Product table. It seems ok. 

However I need to use currency tables also an cannot create relationship. Only one oy of my data table is connected to the currency table. The second one creates inactive relationship. When I am trying to get data from the second table results disappear.

 

I have set both sided relationship.

 

Please help me with this issue.

Thank in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
LivioLanzo Super Contributor
Super Contributor

Re: relationship problem

it looks a bit messy. I would sit down and try to redesign it if I were you, and would get rid of the bi-directional relationships which, I think, only bring problems

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

View solution in original post

5 REPLIES 5
LivioLanzo Super Contributor
Super Contributor

Re: relationship problem

Hi @OSS

 

what does your data model look like?  

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

OSS Member
Member

Re: relationship problem

Hi @LivioLanzo

 

I am afraid I don't understand what do you mean. But I add screen view of my data. Hope it will help.

relationship.PNG

Highlighted
LivioLanzo Super Contributor
Super Contributor

Re: relationship problem

it looks a bit messy. I would sit down and try to redesign it if I were you, and would get rid of the bi-directional relationships which, I think, only bring problems

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

View solution in original post

OSS Member
Member

Re: relationship problem

This is exactly my problem. Let me ask question in another way. I will delete all relationships. Please help me with this issue. How do I need connect two vlookup tables (they are in the right side) with four data tables (on the left side)

 

I need connect data tables via product name (in one table) and currency (in another table)

OSS Member
Member

Re: relationship problem

dear @LivioLanzo thank you for your suggestion. Changing filter direction to single solved my problem. Thank you

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: 41 members 1,047 guests
Please welcome our newest community members: