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 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

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi Anonymous , 

    Yes, I know, you want to use slicer to get corresponding value, but sometimes relationship can't achieve this directly, so we might need use measure to achieve this. If possible could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business), the link you provide can't be available currently)? Then I will help you more correctly.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi