DAX Statistical - VARX.S function


Advertisements

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]) 
dax_functions_statistical.htm

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements