cancel
Showing results for
Did you mean:
Helper III

## Missing 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]

Split (Percent of Parent Total)

Split =
IF (
ISFILTERED ( PRODUCT_MASTER[Full Part Description] ),
[PercentOfFullPart],
IF (
ISFILTERED ( PRODUCT_MASTER[Product Class] ),
[PercentOfProductClass],
IF (
ISFILTERED ( PRODUCT_MASTER[Product Groups] ),
[PercentOfProductGroup] / [PercentOfProductGroup],
IF ( ISFILTERED ( Customer_Master[Customer] ), 1 )
)
)
)

1 ACCEPTED SOLUTION
Super User

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

Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
Check out my latest book!

2 REPLIES 2
Community Support

Hi @Tuan ,

Do you mean the result is totally incorrect or the visual cannot show your expected result?

If this post helps, then please consider Accept it as the solution to help the other members find it.
Super User

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

Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
Check out my latest book!

Announcements