Forum Discussion

Digger's avatar
Digger
Icon for Post Patron rankPost Patron
4 years ago
Solved

Wrong totals

I use measure

Payments =
SUMX (
SUMMARIZE ( Table, Table[_Eur_Pay],Table[id], Table[type] ),
Table[_Eur_Pay]
)
-------------------------------------
Products =
SUMX (
SUMMARIZE ( Table, Table[_Eur_Prod],Table[id]),
Table[_Eur_Prod]
)
-------------------------------------
_Price_Diff = [Payments]-[_Eur_Prod]

Calculated columns formulas

_Eur_Pay =
IF(
[currency] in {"Eur",""}
,[amount]
,[amount]/[Currency_rate.Payments]
)
-------------------------------------

_Eur_Prod =
IF(
[order_products.currency] in {"Eur",""}
,[order_products.price]
,[order_products.price]/[Currency_rate.Products]
)

But i getting wrong totals, and Price difference not counting 😕
 

 

Then i export to Excel i got totals

 

Why this **bleep** happenig always in PBI? :////

How to debug totals and found what is wrong?

Need Help
Show and Tell
Tips and Tricks