Forum Discussion
Advocate IIMatrix 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 🙂
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
3 Replies
- Greg_Deckler
Community Champion
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- DuaneDLB
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
SDittmannFleetAdvocate IV
The second link was the key to success! Thanks!
