@nainiu440,
Definitely never seen that error before, but looks likes @BrianJ solution works.
Also, might want to be careful adding calculated columns in the summarized function. Usually not a problem but when you mix together a filter and the row context in one function it can lead to some interesting results and could be a potential performance hit. I’d use AddColumns and then summarized
ADDCOLUMNS(
SUMMARIZE(
‘Regions Table’,
‘Regions Table’[City]
),
“Total Sales”, [Total Sales]
)
