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'...
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