Forum Discussion

kozlevchar's avatar
kozlevchar
Resolver I
7 years ago

YTD Measure Total in wrong Column

I have a unique problem.  I've created almost identical measures below:

 

Consumer Complaints 2018 YTD = CALCULATE(SUM('QA Data'[Total Complaints]) , DATEADD(DATESYTD('Calendar'[Date]), -1,YEAR))

Consumer Complaints 2019 YTD = CALCULATE(SUM('QA Data'[Total Complaints]) , DATEADD(DATESYTD('Calendar'[Date]), 0,YEAR))

 

The 2018 YTD Total has the 2019 numbers in it and the 2019 YTD has NO TOTAL:

 

 

[Total Complaints] are set to Sum on Default Summarization.  Data Type is Whole Number.  I am using a Clanader Table.

 

How do I add filters to this get the correct totals???

 

Any help would be appreciated.

 

Thanks so much,

 

John 

Need Help

5 Replies

    • kozlevchar's avatar
      kozlevchar
      Resolver I
      7 years ago

      The last date of my calander table goes to 12/31/2020 so 2019 has all dates in the date column.  Is this what you are referring to?

  • kozlevchar's avatar
    kozlevchar
    Resolver I
    7 years ago

    Another piece of information...

     

     

     

     

    The 2019 YTD measure is summing on the TOTAL line of thre 2018 YTD measure. 

     

    1513+176+155+211+54+0=2,209