cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tuan
Helper III
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
Greg_Deckler
Super User
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!

View solution in original post

2 REPLIES 2
v-eachen-msft
Community Support
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.
Greg_Deckler
Super User
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!

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

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

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors