Forum Discussion
Conditional Filter On Different Tables
Hi All. I have an optimization question. Currently I have a measure that returns the correct values in which I'm looking for. The measure is as followed: VAR _DateFilter = DATESBETWEEN(Dim_Calen...
Been beating around this for a while. I think this error message says it most succinctly
The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column.
I haven't found a way around this. Looks like your original approach is the only one that works since each calculate filter there really only uses one column. It does not seem to be possible to hot swap columns inside a filter.
The {} or ALL() thing is a red herring, unrelated to the issue.