Forum Discussion

Helper I

9 years ago

Solved

Total

Hi, could you help me?

I am new in Power BI , MAybe do you know how I can get the correct total?

Volumn =
SUM('Лист1'[Price]) * SUM('Лист1'[Quantity])

52 and 70 are not correct

Greg_Deckler
9 years ago
This is a classic issue, see the explanation and solution here:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
v-sihou-msft
9 years ago
madji

Just use SUMX instead of SUM.

Volume = SUMX(Table,Table[Price]*Table[Quantity])

Regards,

2 Replies

v-sihou-msft
Microsoft Employee
9 years ago
madji

Just use SUMX instead of SUM.

Volume = SUMX(Table,Table[Price]*Table[Quantity])

Regards,
Greg_Deckler
Community Champion
9 years ago
This is a classic issue, see the explanation and solution here:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Related content