Share via


TRUE Function (DAX)

Returns the logical value TRUE.

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-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())

See Also

Other Resources

FALSE Function (DAX)

NOT Function (DAX)

IF Function (DAX)

Function Reference (DAX)