Total

[madji]

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 · Accepted solution]

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 · Accepted solution]

@madji

Just use SUMX instead of SUM.

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

Regards,

[Greg_Deckler · Accepted solution]

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