Forum Discussion
Total Error
Greetings community. My query is as follows: I've generated a Power BI report, where the total sale is equal to the price for units sold. The total for each row is correct, but the grand total gives...
Hi Syndicate_Admin
Try to use sumx instead of sum.
+
Please refer to the linked blog posts :
https://blog.finance-bi.com/power-bi-totals-incorrect/
https://archerpoint.com/how-to-make-measures-total-correctly-in-power-bi-tables/
for more specific assistance
please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.