FALSE Function (DAX)
Returns the logical value FALSE.
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-False |
Column Labels |
|
|
|
|
|
Row Labels |
2001 |
2002 |
2003 |
2004 |
|
Grand Total |
Accessories |
FALSE |
FALSE |
TRUE |
TRUE |
FALSE |
TRUE |
Bikes |
TRUE |
TRUE |
TRUE |
TRUE |
FALSE |
TRUE |
Clothing |
FALSE |
FALSE |
FALSE |
FALSE |
FALSE |
TRUE |
Components |
FALSE |
FALSE |
FALSE |
FALSE |
FALSE |
FALSE |
|
FALSE |
FALSE |
FALSE |
FALSE |
FALSE |
FALSE |
Grand Total |
TRUE |
TRUE |
TRUE |
TRUE |
FALSE |
TRUE |
=IF(SUM('InternetSales_USD'[SalesAmount_USD]) >200000, TRUE(), false())