Forum Discussion

PBI5851's avatar
PBI5851
Helper V
5 years ago
Solved

Proper relationship mapping recommendation

Hello,  I have three tables Table A, Table B, Table C. The relationship is such that A is connected to B on a 1-Many relation. A is connected to C on a 1-Many relation.    A.account_id = B.Account...
Need Help
  • v-xicai's avatar
    v-xicai
    5 years ago

    Hi PBI5851 ,

     

    You may use function such as RELATED(), RELATEDTABLE() and USERELATIONSHIP() in your DAX formula for TableB and TableC.

     

    For example:

     

    Count= CALCULATE(COUNT(TableB[Value]),USERELATIONSHIP(TableB[account_id],TableC[account_id]))

     

    In addition, you may go to Query Editor, use "Merge Queries" for TableB and TableC to combine into a single table.

     

    Or you may try to change the Cross filter direction of relationships above from Single to Both.

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Community Support
5 years ago

Hi PBI5851 ,

 

You may use function such as RELATED(), RELATEDTABLE() and USERELATIONSHIP() in your DAX formula for TableB and TableC.

 

For example:

 

Count= CALCULATE(COUNT(TableB[Value]),USERELATIONSHIP(TableB[account_id],TableC[account_id]))

 

In addition, you may go to Query Editor, use "Merge Queries" for TableB and TableC to combine into a single table.

 

Or you may try to change the Cross filter direction of relationships above from Single to Both.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.