Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Many to Many relationship

Hi I have a table Called OpportunitywithOpportunitylines (giving details about the opportunity) and I have anothe table called OpportunityTeam. the table OpportunitywithOpportunitylines has the fol...
Need Help
dax's avatar
dax
Community Support
6 years ago

Hi Anonymous , 

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's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Zoe

    I've attache the file (Link ) for your reference.

    I've two tables

    1  - Table OpportunitywithOppLine : where I have the opportunity (Header) with their opportunity lines (Detail) I'll sum the totalprice

    2- OpportunityTeam : where I have all team members working on opportunities.

     

    Opportunityteam has many to many relationship with  OpportunitywithOppLine

    what I need is to be able to filter by team member and have the totalprice of opportunities where he is a member

     

    hope this will help

     

    thank you for your support

    imbrg 

    • dax's avatar
      dax
      Community Support
      6 years ago

      Hi Anonymous , 

      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.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I've two tables

        I have created some measures from the table “OpportunitywithOppLine”

        For instance TotalPipeline = sum(Totalprice)

         And I would like to be able to filter (slice) by user who are on the table

        OpportunityTeam

         

        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

         To OpportunitywithOppLine

         

        Please let me know if this is clear and you can support

         

        Thank yoou Zoe

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Zoe Zhi

    is the data I sent helpful tosupport my request

    thank you in advance

     

    regards

    imbrg