DAX Statistical - STDEVX.P function


Advertisements

Description

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

Syntax

STDEVX.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).

Return Value

A real number.

Remarks

DAX STDEVX.P function evaluates an expression for each row of table and returns the standard deviation of an expression assuming that the table refers to the entire population. If the data in the table represents a sample of the population, you should use DAX STDEVX.S function instead.

STDEVX.P uses the following formula −

$$\sqrt{\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

= STDEVX.P (Sales,[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