DAX: The very long message "The semantic error or perhaps this error or this error.."
One day, I was working with a DAX expression in PowerPivot (Excel 2013) and I got the following error:
"Semantic error: The value for column 'Date' in Table 'dimCalendar' cannot be determined in the current context. Check that all columns in referenced in the calculation expression exist, and that there are no circular dependencies. This can also occur when the formula for a measure refers directly to a column without performing any aggregation -- such as sum, average, or count-- on that column. The column does not have a single value, it has many values, one for each row in the table, and now row has been specified."