## How does the STDEV.P function (DAX) work?

The STDEV.P function (DAX) returns the standard deviation of the entire population.

## STDEV.P Formula Syntax

STDEV.P(
<ColumnName>
)

## How do you use the STDEV.P function?

This function is used to calculates the standard deviation for a sample set of data. The STDEV.P calculates standard deviation using the “n” method, ignoring logical values and text.

## Related Support Forum Posts

Difference between stdev measures that are similar
Standard deviation and median while filtering measures using slicers
Dax Calculation question

## Considerations when using the STDEV.P function

1. STDEV.P assumes that the column refers to the entire population. If your data represents a sample of the population, then compute the standard deviation by using STDEV.S.
2. STDEV.P uses the following formula:√[∑(x – x̃)²/n]where x̃ is the average value of x for the entire populationand n is the population size
3. Blank rows are filtered out from columnName and not considered in the calculations.
4. An error is returned if columnName contains less than 2 non-blank rows

This DAX function may return different results when used in a model that is deployed and then queried in DirectQuery mode.

## Formula examples using the STDEV.P function

=STDEV.P(InternetSales_USD[SalesAmount_USD])

=STDEV.P(A3:A12)

=STDEV.P(C5:C16,E5:E16,G5:G16)

## Related Course Modules 