DAX Calculations with Invalid Boolean Predicates
Eugene Meidinger takes us through a DAX error:
Whenever you start trying to use more complicated filters in the CALCULATE or CALCULATETABLE functions in DAX, you may start to get the following error:
A function ‘MAX’ has been used in a True/False expression that is used as a table filter expression. This is not allowed.
Read on for Eugene’s explanation and what you can do about it.