# AVERAGEADAX Function (Aggregation) Not recommended

Returns the average (arithmetic mean) of the values in a column. Handles text and non-numeric values.

## Syntax

AVERAGEA ( <ColumnName> )
Parameter Attributes Description
ColumnName

A column that contains the values for which you want the average.

## Return values

Scalar A single value of one these types: currency, decimal.

## Remarks

The AVERAGEA function takes a column and averages the numbers in it.
Whenever there are no rows to aggregate, the function returns a blank.

AVERAGEA manages a Boolean data type as an integer, where FALSE is 0 and TRUE is 1.
AVERAGEA always consider a string as 0, regardless of the content of the string.

It is useless to use this function in DAX with a string column because the result is always 0, resulting in a different result compared to the corresponding AVERAGEA function in Excel. In order to calculate the average of the numbers included in a column with a string data type, use AVERAGEX instead of AVERAGEA converting the column into a number using VALUE:

## Examples

```-- The AVERAGEA syntax does not consider the content
-- of a string column (as Excel does)
AVERAGEA ( table[column] )

-- The following AVERAGEX syntax works correctly
-- when table[column] is a string
AVERAGEX (
table,
VALUE ( table[column] )
)
```

## Related functions

Other related functions are:

Last update: Nov 21, 2020     » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://docs.microsoft.com/en-us/dax/averagea-function-dax

# Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

# Row Context

This expression is executed in a Row Context. Click to read more.

# Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

# Not recommended

The use of this parameter is not recommended.

# Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

# Deprecated

This parameter is deprecated and its use is not recommended.

# DirectQuery compatibility

Limitations are placed on DAX expressions allowed in measures and calculated columns.
The state below shows the DirectQuery compatibility of the DAX function.

### Contribute

Want to improve the content of AVERAGEA? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.