TechNet
Export (0) Print
Expand All

TRUE Function (DAX)

 

Returns the logical value TRUE.

Syntax

TRUE()

Return Value

Always TRUE.

Remarks

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

Example

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

See Also

FALSE Function (DAX)
NOT Function (DAX)
IF Function (DAX)
DAX Function Reference

Community Additions

Show:
© 2016 Microsoft