Many to Many relationship

Question

HiI have a table Called OpportunitywithOpportunitylines (giving details about the opportunity) and I have anothe table called OpportunityTeam.the table&nbsp;OpportunitywithOpportunitylines has the following fields : OpportunityId,Opportunity lineId, Currency, Amount, BusinessUnit,.....&nbsp;The OpportunityTeam table defines for each opportunity the members who will be part fo this opportunity with their roles :the table has : OpportunityTeamId, OpportunityId, UserId, username, UserRole.&nbsp;I am not using Opportunityteam table fo any calculation but only to slice and dice :&nbsp; for instance I need to know the Total amount of opportunity or their count.&nbsp;the relaionship between the two table is many to many&nbsp;can you please guide me how I can make 1 to many relationshipor between the two tables and what kind of bridge I can use&nbsp;thank you for your supportimbrg

dax · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;
I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.Best Regards,Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Hi ZoeI've attache the file (Link&nbsp;) for your reference.I've two tables1&nbsp; - Table&nbsp;OpportunitywithOppLine : where I have the opportunity (Header) with their opportunity lines (Detail) I'll sum the totalprice2-&nbsp;OpportunityTeam : where I have all team members working on opportunities.&nbsp;Opportunityteam has many to many relationship with&nbsp;&nbsp;OpportunitywithOppLinewhat I need is to be able to filter by team member and have the totalprice of opportunities where he is a member&nbsp;hope this will help&nbsp;thank you for your supportimbrg&nbsp;

anonymous · Answer

Zoe Zhiis the data I sent helpful tosupport my requestthank you in advance&nbsp;regardsimbrg

dax · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;
I get the source, so if possible, could you please inform me your expected output? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.Best Regards,Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;

anonymous · Answer

I've two tablesI have created some measures from the table “OpportunitywithOppLine”For instance TotalPipeline = sum(Totalprice)&nbsp;And I would like to be able to filter (slice) by user who are on the tableOpportunityTeam&nbsp;Since the relationship between the two tables is many to many, I am not able to perform this action.What I was havig in mind is to create a kind of bridge between the two tables and then be able to filter and have the filter propagate from OpportunityTeam&nbsp;To OpportunitywithOppLine&nbsp;Please let me know if this is clear and you can support&nbsp;Thank yoou Zoe

Forum Discussion

Many to Many relationship

6 Replies

Related content

Understanding many to many relationship

Behaviour of many to many relationships

Perfromance Optimization | Many to Many Relationships Analysis

One to Many Relationship Problem

Many- Many Relationship