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