Downloads
DAXLogicalBeginner

FALSE

Returns the logical value FALSE.

Syntax
FALSE() (also written FALSE without brackets in most places)

Returns: FALSE (a logical value).

What it does

FALSE returns the logical value false. Like TRUE, it is a constant that does not depend on the data. It is used to set a flag to false, to fill a default in a test, or to write the explicit "no" branch of a rule. In a filter, FALSE() can also be used to say that nothing should match.

Syntax and arguments

FALSE takes no arguments. Write FALSE() with brackets for clarity. Both FALSE and FALSE() are accepted in most places.

Example

A close checklist flags an account as ready to post only when it has been reconciled and approved. The default is not ready.

Ready To Post =
IF(
    AND(
        Accounts[IsReconciled] = TRUE(),
        Accounts[IsApproved] = TRUE()
    ),
    TRUE(),
    FALSE()
)

The explicit FALSE() shows the reader exactly what the default is. An account that fails either check is reported as not ready, and the list of not-ready accounts drives the close meeting.

Example: a second, different use

A measure that returns nothing when the report should be empty, using FALSE() to block a filter:

Show Totals = IF(ISFILTERED(Sales[CustomerKey]), TRUE(), FALSE())

This is a simple illustration of a logical switch. Real models use it inside a CALCULATE filter or a visual rule, so read the filter behavior carefully before you use it.

Things to watch

In business terms

FALSE shows up in controls and checklists: an approval that is not given, an account not yet reconciled, a vendor not yet verified. Writing the default explicitly is good practice in any audit trail.

Related functions

All DAX functions · View as Markdown · DAX fundamentals