Marco Russo and Alberto Ferrari catalog some errors:
The expression contains columns from multiple tables, but only columns from a single table can be used in a True/False expression that is used as a table filter expression.
This error is seen when the predicate includes column references from more than one table. For example, if we need a measure that returns the sales made to customers living in the same country as the store, we could try to write the following measure:
Read on for several examples and solid guidance on how to resolve these common issues.