Sum accross 3 related tables

[polmar]

I don't know how to explain this. I have three tables as in the picture.

I need to sum the Agr.Saldo field in the "ApuntesAgrupados" table, at two levels: per Account and per Epigraph (Charter), but in the epigraphs you can repeat "n" times the same account. So, when I apply that the formula 

Saldo = SUMX(RELATEDTABLE(ApuntesAgrupados); ApuntesAgrupados[Agr.Saldo])

the amount per account is correct (ratio many to 1) but the total per Epigraph returns me the grand total, and not the sum of the accounts that make it up.

I don't know if I can make myself clear.... If yes, any ideas please?

[v-sihou-msft · Accepted solution]

@polmar

In this scenario, you have "1 to many" relationship with single direction from Account to ApuntesAgrupados. So dim account can slice ApuntesAgrupados.

However, you also have "1 to many" relationship with single direction from Account to Chapter. When you analyze on Chapter level, it will always take the aggregation of account for each chapter. So in your scenario, you should change this direction into "both", and put chapter under account level. 

Regards,