FALSE
Returns the logical value FALSE.
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
- FALSE is a value, not a missing answer. A blank is different, so use BLANK() when there is no answer.
- A logical value does not sum. Convert it to 0 and 1 with IF when you need a count.
- Comparing a logical column with FALSE() is a common way to filter a list. Make sure the column really holds logical values.
- Use the explicit FALSE() in branches of IF or SWITCH so the default is clear to the reader.
- Do not confuse FALSE with zero. In DAX they are different types.
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.