Forum Discussion

Roger_McCallen's avatar
Roger_McCallen
Frequent Visitor
3 years ago
Solved

Table calculating totals incorrectly

I have a table that is calculating row totals correctly, however the columns are not calculating correctly. The measure is taking the total sales in units multiplied by the number of pieces within ea...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Roger_McCallen First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

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: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8