Forum Discussion

Jon_H1991's avatar
Jon_H1991
Frequent Visitor
2 years ago

TotalYTD function with slicer

Hi,

 

I having issues with the totalYTD function for a cumulative yearly total filtered by a location slicer. The TotalYTD function is summing correctly however, when filtering by 'site', it doesn't filter correctly. I'm hoping someone can help.

 

Measure:

Total Revenue YTD =
TOTALYTD(
[Total Revenue YTD], 'Date'[Date])

Kind Regards,

Jon

5 Replies

  • RSC's avatar
    RSC
    Helper I
    2 years ago

    Hi, Jon_H1991 
    Have you used 

    Total Revenue YTD =
Calculate(TOTALYTD(
[Total Revenue YTD], 'Date'[Date]))
    • Jon_H1991's avatar
      Jon_H1991
      Frequent Visitor
      2 years ago

      Hi RSC,

       

      Same result i'm afraid.

      Kind Regards,

      Jon

       

  • Jon_H1991's avatar
    Jon_H1991
    Frequent Visitor
    2 years ago

    To add, I have also tried the following with no luck:

    calculate([Total Revenue],
    filter (ALLSELECTED('Date'[Date]),
    'Date'[Date] <= MAX( 'Date'[Date])))
  • RSC's avatar
    RSC
    Helper I
    2 years ago

    Okay, no worries at all,

     

    Total Revenue YTD =
TOTALYTD(
    [Total Revenue], 
    'Date'[Date], 
    ALL('Table_name_for_site'[Site])
)

     

    Can you try this one!

     

    • Jon_H1991's avatar
      Jon_H1991
      Frequent Visitor
      2 years ago

      Hi RSC,

       

      It is slightly better but missing the other two sites; it sums up against just one.

       

      Kind Regards,

      Jon