cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
happyalibaba Frequent Visitor
Frequent Visitor

Grand total for a measure doenst add up

Below 10% measure doesn't add up in the grand total.. Please help

Capture.PNGCapture.PNG2.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
happyalibaba Frequent Visitor
Frequent Visitor

Re: Grand total for a measure doenst add up

My husband fixed it using below reference:

 

https://powerpivotpro.com/2012/03/subtotals-and-grand-totals-that-add-up-correctly/

 

So he added another measure below

 

=IF(COUNTROWS(VALUES('Tariffed Receipts Reporting 4'[FiscalMonthYearName]))=1,
[10%],
SUMX(VALUES('Tariffed Receipts Reporting 4'[FiscalMonthYearName]), [10%])
)

 

Now the grand total is correct

 

Capture.PNG3.PNG

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Grand total for a measure doenst add up

Hello @happyalibaba 

In the context of the total row [Current 10%] is not blank so your SUMX never gets [Sum of 301 Tariff value].  You need to move the IF inside the SUMX like so.

10% =
SUMX (
    VALUES ( YourTable[FiscalMonthYearName] ),
    IF ( [Current 10%] = BLANK (), [Sum of 301 Tariff value], [Current 10%] )
)

This will move the check on [Current 10%] into the iteration over  VALUES ( YourTable[FiscalMonthYearName] ).

 

You can try it with the old VALUES list just moving the if, not sure if that will give you what you want though.

10% =
SUMX (
    VALUES ( 'Tariffed Receipts Reporting 4'[List] ),
    IF ( [Current 10%] = BLANK (), [Sum of 301 Tariff value], [Current 10%] )
)
happyalibaba Frequent Visitor
Frequent Visitor

Re: Grand total for a measure doenst add up

My husband fixed it using below reference:

 

https://powerpivotpro.com/2012/03/subtotals-and-grand-totals-that-add-up-correctly/

 

So he added another measure below

 

=IF(COUNTROWS(VALUES('Tariffed Receipts Reporting 4'[FiscalMonthYearName]))=1,
[10%],
SUMX(VALUES('Tariffed Receipts Reporting 4'[FiscalMonthYearName]), [10%])
)

 

Now the grand total is correct

 

Capture.PNG3.PNG

View solution in original post

happyalibaba Frequent Visitor
Frequent Visitor

Re: Grand total for a measure doenst add up

@jdbuchanan71  thanks for trying. 🙂

Super User
Super User

Re: Grand total for a measure doenst add up

Glad you were able to find a solution. Smiley Happy

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 416 members 4,204 guests
Please welcome our newest community members: