cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ModernAchilles Regular Visitor
Regular Visitor

Summing Totals Help

Hi,

 

So I can't seem to get the logic behind getting these summed totals correct.

 

I have an if calculation that returns the Unit shortfall, but need the totals to be correct.

unit short.PNG

I tried creating this measure and DAX to ge the correct Totals, but it seems it did the calculation to every row in my table. Where should I put another filter on to make sure it only grabs the releveant coloumns for my totals?

 

 

Summs of Short.PNG

 

 

 

Thanks! Here is the Data that its not summing correctly with this logic.

 

 

Totals Summed.PNG

 

 

Thanks again!

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Summing Totals Help

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


3 REPLIES 3
Highlighted
Super User
Super User

Re: Summing Totals Help

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


ModernAchilles Regular Visitor
Regular Visitor

Re: Summing Totals Help

Hi Greg, Thanks for the help! That worked, I appreciate it! I'll give you kodos when it seems my browser will let me. Thanks again!
Super User
Super User

Re: Summing Totals Help

No worries, glad it worked for you!


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!