Forum Discussion
Custom Total in Matrix
NJ81858 Right, so as described in those articles, I generally get the measure correct for an individual row. Then, create a new measure that uses that measure for individual rows but performs a SUMMARIZE or GROUPBY for subtotal rows and grand total rows. You can use ISINSCOPE or HASONEVALUE to identify where you are in the hierarchy.
NJ81858 Here are two techniques for modifying the total row/aggregate row of a matrix:
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
Also, MM3TR&R: Matrix Measure Total Triple Threat Rock & Roll - Microsoft Power BI Community
Update: I did get the correct measure, it just won't show up unless there is a subtotal in there with the wrong value.