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: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
558 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!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Message 2 of 3
653 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
644 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
645 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!: The Definitive Guide to Power Query (M)

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

View All