- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
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). |
Return Value
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])