Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
DuaneDLB
Helper I
Helper I

Matrix total row will not compute correctly for some measures

Need help undestand why some measures will add correctly and others will not. 

 

In the screen shot below there are two columns (Driver Miles Running TimeValue and _Incentive Hrs v2). 

 

The Driver Miles Running TimeValue data is correct.  The '_Incentive Hrs v2' is a test measure I am creating to test how I can take one measure and add math rules to obtain results.    You will notice I tested my measure by simply subtracting 10 from the measure called 'Driver Miles Running TimeValue'.  Even though the detail row computed correctly the aggregate (total) row did not for the measure '_Incentive Hrs v2'.   How can I manipulate measures to make sure their totals are the sum of the detail rows?  I am dealing with aggregate aggravation.  Please help.  Thanks 🙂 

 

Capture.JPG

 

_Incentive Hrs v2 = [Driver Miles Running TimeValue] - 10
 
Driver Miles Running TimeValue = sumx(DriverMove,DriverMove[Driver ProRate Running Miles]) / 'WhatIF MPH TimeValue'[WhatIF MPH TimeValue Value]
1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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



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

3 REPLIES 3
Greg_Deckler
Super User
Super User

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



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...

The second link was the key to success! Thanks!

Your reading did help, even though I do not undestand why we have to build those memory tables to compute the measure totals. 

As you can see below in my scree shot I focused on 'Driver Incentive Hrs Pay' that was not computing correclty.  Using your suggested reading, I created 3 test measures (_Test, _Test2 and Test3).  After I created _Test the total was correct then I created another measure to only display values greater than 0. You wil notce in the '_Test2' the Total value was same as '_Test'. So, I applied your rules using the '_test2' measure to build measure '_Test3' and the total values came out perfect.   Now I have to apply the same rules to the other column called 'Driver Incentive Miles Pay' and I will be done with this task.  Thanks again for your help. Now I know why they call this Aggregate Aggravation.  lol 

 

 

Capture2.JPG

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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