Missing Grand Total in a Measure

[Tuan]

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 )
        )
    )
)

[v-eachen-msft]

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.

[Greg_Deckler · Accepted solution]

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