Forum Discussion
Tuan
Helper III
Helper IIIMissing Grand Total in a Measure
I'm missing the Grand Total after using a Multiplication caclulation. Any help would be greatly appreciated. Formula with issue Allocated Expense = [Trade Expense] * [Split] Trade Expen...
Not sure what you mean by "missing". Is the grand total wrong? Could be 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
v-eachen-msft
Community Support
Community SupportHi Tuan ,
Do you mean the result is totally incorrect or the visual cannot show your expected result?
You could share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to OneDrive for Business and share the link here.