Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Matrix total is not matching

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 

 

 

 

Need Help
  • danextian's avatar
    danextian
    4 years ago

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

     

1 Reply

  • danextian's avatar
    danextian
    Super User
    4 years ago

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