Matrix total is not matching

[Anonymous]

Hi , 

I am trying to work on YTD calculation for net sales from 2020-2022... and I am trying to see that in months and years so When I create the matrx the totals doesnot match... or is there a way to change the totals in a matrix .

 the highlighted ones in yellow doesnot add up is there a way I can work on it 

[danextian · Accepted solution]

Hi @Anonymous ,

You can create another measure that will sum the YTD and LYTD values.

YTD SUM =
SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( Dates, Dates[Year], Dates[Month Name] ),
        "YTD", [YTD Measure]
    ),
    [YTD]
)