Forum Discussion
Community ChampionDealing with Measure Totals
Helper IVDue to how the data is structured I had to create columns to break out count versus the dollar amounts associated with each itemcode in the dataset Each itemcode has a column for quantity and charge. All I had to do was drag each column into the values field in the matrix to get everything to total up. Do the totals calcualted or averages matter if the totals come from a measure versus a column?
- Greg_Deckler
cheid_4838 It certainly does matter. Column totals always work. Measure totals, it depends. Here is actually a better article 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 - cheid_4838
I guess I am trying to determine how this applies to me if the column totals are accurate since they are coming from column totals not measures. I under how the averages will not be correct if calculating a measure, but shouldn't the averages be accurate since the totals come from columns and not measures? Thanks for your help.
