Relatedtable issue

[vanessafvg]

I have 3 tables, 

1. income

2. practices

3. leads

i want to pull back the income from income where they are related to leads but the relationship is through the practice table

Leads Income (YTD) = CALCULATE(Income[Plan Income (YTD)], RELATEDTABLE(Leads))

this works to a degree but unfortunately it brings everything back from leads. and my date filter on leads is not working.  What is the best way to bring something back from another table, ie  many to many relationship

[Phil_Seamark]

HI @vanessafvg

You could experiment with the "bi-directional" relationship setting as one approach.  By setting this to Both on one of the relationships coming from your Practices table it may solve your issue.  MS introduced this feature as one way to address many to many challenges in your data.  This may solve your issue without requiring you to restructure your tables.

[vanessafvg]

@Phil_Seamark i did have it on but it was giving me funny resuts elswhere, guess i better tweak my relationships a bit!  thanks

[Anonymous]

For funzies try:

Leads Income (YTD) = CALCULATE(Income[Plan Income (YTD)], Practice)