STDEVX.P
The standard deviation of an expression over a table's rows, taken as the whole population.
Group: Aggregation. Compatible with DAX.
Syntax
STDEVX.P ( <table>, <expression> )| Parameter | Type | Description |
|---|---|---|
table | Table | The rows to go through. |
expression | Expression evaluated for each row | The number worked out for each row. |
Returns
Number. How far the results spread around their mean, when they are all there is.
Remarks
- Rows where the expression is blank are left out.
- Over an empty table the result is BLANK; over a single row it is 0.
Examples
Eight values with a mean of 5
Their mean is 5 and the population deviation exactly 2.
EVALUATE
ROW ( "Deviation", STDEVX.P ( DATATABLE ( "Value", INTEGER, { { 2 }, { 4 }, { 4 }, { 4 }, { 5 }, { 5 }, { 7 }, { 9 } } ), [Value] ) )| Deviation |
|---|
| 2 |