TotalYTD function with slicer

[Jon_H1991]

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

[RSC]

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]

Hi RSC,

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

Kind Regards,

Jon

[Jon_H1991]

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

calculate([Total Revenue],

filter (ALLSELECTED('Date'[Date]),

'Date'[Date] <= MAX( 'Date'[Date])))

[RSC]

Hi, @Jon_H1991 
Have you used 

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

[Jon_H1991]

Hi RSC,

Same result i'm afraid.

Kind Regards,

Jon