# DAX Statistical - VARX.P function

## Description

Evaluates the given expression for each row of the given table, and returns the variance of the expression assuming that the table refers to the entire population.

## Syntax

VARX.P (<table>, <expression>)


## Parameters

Sr.No. Parameter & Description
1

table

A table or any DAX expression that returns a table of data.

2

expression

Any DAX expression that returns a single scalar value, where the expression is to be evaluated multiple times (for each row/context).

A real number.

## Remarks

DAX VARX.P function evaluates <expression> for each row of <table> and returns the variance of <expression> assuming that <table> refers to the entire population. If <table> represents a sample of the population, then use DAX VARX.S function.

$${\sum\frac{(x\:-\:\bar{x})^{2}}{N}}$$

Where, $\bar{x}$ the average value of $x$ for the entire population, and

N is the population size

Blank rows are filtered out from columnName and not considered in the calculation.

An error is returned if columnName contains less than 2 non-blank rows.

## Example

= VARX.P (Sales, [Sales Amount])

dax_functions_statistical.htm 