Table of contents
TOC
Collapse the table of content
Expand the table of content

FALSE Function (DAX)

Owen Duncan|Last Updated: 5/22/2018

Returns the logical value FALSE.

Syntax

FALSE()  

Return Value

Always FALSE.

Remarks

The word FALSE is also interpreted as the logical value FALSE.

Example

The formula returns the logical value FALSE when the value in the column, 'InternetSales_USD'[SalesAmount_USD], is less than or equal to 200000.

The following table shows the results when the example formula is used with 'ProductCategory'[ProductCategoryName] in Row Labels and 'DateTime'[CalendarYear] in Column Labels.

True-FalseColumn Labels
Row Labels2005200620072008Grand Total
AccessoriesFALSEFALSETRUETRUEFALSETRUE
BikesTRUETRUETRUETRUEFALSETRUE
ClothingFALSEFALSEFALSEFALSEFALSETRUE
ComponentsFALSEFALSEFALSEFALSEFALSEFALSE
FALSEFALSEFALSEFALSEFALSEFALSE
Grand TotalTRUETRUETRUETRUEFALSETRUE
=IF(SUM('InternetSales_USD'[SalesAmount_USD]) >200000, TRUE(), false())  

See Also

TRUE Function (DAX)
NOT Function (DAX)
IF Function (DAX)
DAX Function Reference

© 2018 Microsoft