Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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!
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!
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.
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!
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)
dear @LivioLanzo thank you for your suggestion. Changing filter direction to single solved my problem. Thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |