# DAX Statistical - VARX.S 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 a sample of the population.

## Syntax

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

VARX.S uses the following formula −

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

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

n is the sample 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.S (West_Sales, West_Sales[Amount])

dax_functions_statistical.htm

## Useful Video Courses

Video

#### Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Video

#### Mastering DAX Studio

Featured

24 Lectures 2 hours

Video

#### DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours