got it.
was bad syntax
correct DAX is
CumulativeGCI MEASURE = CALCULATE( SUM(PBI_KPIs[GCI]), FILTER(ALL('DateKey'[Date]), 'DateKey'[Date] <= MAX ('DateKey'[Date]) ) )
got it.
was bad syntax
correct DAX is
CumulativeGCI MEASURE = CALCULATE( SUM(PBI_KPIs[GCI]), FILTER(ALL('DateKey'[Date]), 'DateKey'[Date] <= MAX ('DateKey'[Date]) ) )
Remember: it is the second mouse that gets the cheese.....