Forum Discussion
Solved
SUMX Calculating wrongly
I am working on a report the is supposed to show invoices and how they impact past, current and future periods. This is done on a calendar month to month basis. All calculations are done by measures....
I managed to find the solution myself. The issue was with rounding the numbers throughout the report, and not the formulas.
You can be sure that Power BI doesn't make any miscalculation 😋
Most probably you made a mistake somewhere creating your measure. Not easy.
Could you share with us an anonymous sample dataset? That will make it way much easier for us to help.
David
I have tried to anonymize it in this pbix
https://www.dropbox.com/s/mzggq2fz9jo9i2s/Subscription%20entry%20normalisation.pbix?dl=0
Thank you David