Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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,
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |