cancel
Showing results for
Search instead 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]``

Trade Expense

``Trade Expense = CALCULATE(SUM('Trade'[Expenses]),'Trade'[Transaction Type]="Trade Expense")``

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

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
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?

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.

Community Support Team _ Eads
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

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

## Helpful resources

Announcements

#### Check it Out!

Click here to read more about the December 2021 Updates!

#### Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

#### Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors