Forum Discussion

Advocate II

6 years ago

Solved

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

Need Help

Greg_Deckler
6 years ago
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

Greg_Deckler

Community Champion

6 years ago

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

SDittmannFleet

Advocate IV

3 years ago

The second link was the key to success! Thanks!

Forum Discussion

Matrix total row will not compute correctly for some measures

Related content

Using SelectedValue in measure for computing volume

Computing Rank using 2 measures

Measure Calculates Correctly but Repeats Across Every Single TransactionID

Workspace Monitoring - compute costs ?

Your Compute session is disconnected