Grand Total is showing incorrect results in matrix and Table.

[Optimusprime_25]

Hello All,

Basically we are calculating YOY% for PY Actuals and SY Actuals (Selected Year), but we are getting wrong results in Grand Total.

Below are the caculations for PY Actuals, SY Actuals  and YOY%

SY Actuals = CALCULATE(SUM(Table[Actual Values]),DATEADD('Date'[Date],0 ,DAY))

PY Actuals = CALCULATE(SUM(Table[Actual Values]),DATEADD('Date'[Date],-1 ,YEAR))

YOY% = ([SY Actuals] - [PY Actuals]) / ([PY Actuals])

SY Actuals and PY Actuals Data Type is Whole Number.

Could you please look into this and provide any solution to rectify the issue.

Thanks in advance.

[v-rongtiep-msft]

Hi @Optimusprime_25 ,

Please have a try.

Create measures base on the above formulas.

SY_Measure =
VAR _1 =
    SUMMARIZE ( table, table[date], "aaa", [SY Actuals] )
RETURN
    IF ( ISINSCOPE ( table[date] ), [SY Actuals], SUMX ( _1, [aaa] ) )

PY_Measure =
VAR _1 =
    SUMMARIZE ( table, table[date], "aaa", [PY Actuals] )
RETURN
    IF ( ISINSCOPE ( table[date] ), [PY Actuals], SUMX ( _1, [aaa] ) )

And so on.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.