Press "Enter" to skip to content

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.