TRUE Function (DAX)
Returns the logical value TRUE.
TRUE()
Always TRUE.
The word TRUE is also interpreted as the logical value TRUE.
The formula returns the logical value TRUE when the value in the column, 'InternetSales_USD'[SalesAmount_USD], is greater than 200000.
The following table shows the results when the example formula is used in a PivotTable, with 'ProductCategory'[ProductCategoryName] in Row Labels and 'DateTime'[CalendarYear] in Column Labels.
| True-False | Column Labels | |||||
|---|---|---|---|---|---|---|
| Row Labels | 2005 | 2006 | 2007 | 2008 | 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())
FALSE Function (DAX)
NOT Function (DAX)
IF Function (DAX)
DAX Function Reference
Community Additions
ADD
Show: