error message when refreshing

[amadeusning]

My report was working perfectly when I refreshed it last time. However today when I try to refresh it again the following columns are in #ERROR. The raw data in these tables looks just like normal. However in the summary table, which I used to summary by week number with some adjustment, all columns relate to these two tables are not working. 

The error message I got is: This expression refers to 'efec9e6d-b8a5-477a-b2dd-5b5cd907eeff', which has an error.

 One of the fomulas I used is: 

Survey Score (RPS) (Current) = CALCULATE(AVERAGE('Raw Data - ServiceNow Survey'[sur_u_score]),'Staff Name List'[New Group]="RPS",FILTER('Week Number','Week Number'[Week Number]=Summary[Week Number]))

Those fomulas used to work perfectly and I did not make any changes since last time.

[v-huizhn-msft]

Hi @amadeusning,

You refresh data in Power BI desktop, right? If it is, if there is any special character not recognize for formula after updated data? Please double check it.

Best Regards,
Angelia