TRUE - Daxplained

Syntax

TRUE( )

Return Values

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.

= IF(SUM('InternetSales_USD'[SalesAmount_USD]) >200000, TRUE(), false())

The following table shows the results when the example formula is used in a report with ‘ProductCategory'[ProductCategoryName] in Row Labels and ‘DateTime'[CalendarYear] in 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`

Other functions related to TRUE are:

Contribute » | Contributors: Rick de Groot

Syntax

Return Values

Remarks

Example

Related functions