Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
madji
Helper I
Helper I

Total

‎07-28-2017 06:34 AM

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

 Screenshot_6.png

 

Labels:
Message 1 of 3
643 Views
0
2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

‎07-28-2017 07:48 AM

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

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Message 2 of 3
738 Views
0
v-sihou-msft
Microsoft Employee
Microsoft Employee

‎08-01-2017 05:57 AM

@madji

 

Just use SUMX instead of SUM.

 

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

 

Capture.PNG

 

Regards,

View solution in original post

Message 3 of 3
729 Views
2 REPLIES 2
v-sihou-msft
Microsoft Employee
Microsoft Employee

‎08-01-2017 05:57 AM

@madji

 

Just use SUMX instead of SUM.

 

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

 

Capture.PNG

 

Regards,

Message 3 of 3
730 Views
Greg_Deckler
Super User
Super User

‎07-28-2017 07:48 AM

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

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Message 2 of 3
739 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

View All