Forum Discussion
Getting Correct Grand Totals Following Measure Column
- 4 years ago
julesdude 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
Hi tamerj1
In the top table of the screenshot I pasted, far right column 'Measure New', the values the measure is displaying aren't adding up to the Total displayed.
That means it's a problem for the pie chart I'm compiling underneath as the figures in that pie chart aren't actually representative of the table above it. The table beneath the pie chart is basically the same data but in a table, to illustrate it another way.
So, I'm hoping for a solution around this common problem.
Sorry I was so busy yesterday I diyhave the chance to look into this. Can you please describe in works what this measure is intended to calculate? Thank you