Incorrect Grand Total of measures

[PBI_newuser]

Hi, how to create a measure to make sure the grand total is the sum of each rows in the table? Below screenshot shows the incorrect total for both fields. Here is the pbix file. 

[CNENFRNL]

Presume that your current measures are correct, the amendment is simple enough,

= SUMX(VALUES('Append Table'[Product]), [Price Impact])

= SUMX(VALUES('Append Table'[Product]), [Volume Impact Total])

[amitchandak · Accepted solution]

@PBI_newuser , the second one has some value in decimal place , so getting rounded of two one value higher. Please changes these measures

Volume Impact = 
  IF (
    MIN ( 'Calendar'[Date] ) > MAX ( 'Append Table'[Date] ),
    CALCULATE (
        SUMX (
            SUMMARIZE ( 'Append Table', 'Calendar'[YearMonth] ,'Append Table'[Product]),
            IF (
                [Volume Last Year] <= 0,
                ( [Revenue] - [Revenue Last Year] ),
                ( [Volume Sum] - [Volume Last Year] ) * [AUSP Last Year]
            )
        ),
        SAMEPERIODLASTYEAR ( 'Calendar'[Date] )
    )*-1,
    SUMX (
        SUMMARIZE ( 'Append Table', 'Calendar'[YearMonth],'Append Table'[Product] ),
        IF (
            [Volume Last Year] <= 0,
            ( [Revenue] - [Revenue Last Year] ),
            ( [Volume Sum] - [Volume Last Year] ) * [AUSP Last Year]
        )
    )
)




Volume Impact Total = SUMX (VALUES('Calendar'[YearMonth]), [Volume Impact] )



Price Impact = 
SUMX(
 SUMMARIZE('Append Table','Calendar'[YearMonth], 'Append Table'[Product]),
    IF([Volume last year]<=0,0,([AUSP Current Year]-[AUSP Last Year])*[Volume Sum]))