Forum Discussion
Table Relationship Doesn't Work.
Hi Anonymous
In fact, many to many relationship works.
In you scenario, why it doesn't work is that:
For example, in my test example,
there are two "a" values in table 1, also two "a" values in table2,
then use "RELATED" function in table1 to get "a" values from table2,
it can't determine which "a" to return.
For this scenario, you could follow my method(use aggregation) in my last post, it is a general way to solve this kind problems.
Regrading using tables with many to many relationship in power bi, you could refer to this article
https://www.seerinteractive.com/blog/join-many-many-power-bi/
Best Regards
Maggie
Hi Anonymous
Using the many-many relationship, i can reproduce the problem as yours.
To avoid this error and get the average, i work as below
add columns from two tables (which relationship is many to many)
Then
Best Regards
Maggie
Hi Maggie,
Wow what an innovative idea.
Thank you so much for your solutions,still i am confuse many to many relationship is not working.
Thanks
Hi Anonymous
In fact, many to many relationship works.
In you scenario, why it doesn't work is that:
For example, in my test example,
there are two "a" values in table 1, also two "a" values in table2,
then use "RELATED" function in table1 to get "a" values from table2,
it can't determine which "a" to return.
For this scenario, you could follow my method(use aggregation) in my last post, it is a general way to solve this kind problems.
Regrading using tables with many to many relationship in power bi, you could refer to this article
https://www.seerinteractive.com/blog/join-many-many-power-bi/
Best Regards
Maggie
Happy Friday and Thank yo so much Maggie for detail explaniations and Link is also very informative.