Estimates standard deviation based on the entire population that results from evaluating an expression for each row of a table.
The table containing the rows for which the expression will be evaluated.
The expression to be evaluated for each row of the table.
The standard deviation of the entire population.
STDEVX.P assumes that the column refers to the entire population.
To compute the standard deviation with a sample of the population, use STDEVX.S.
Learn more about STDEVX.P in the following articles:
DAX includes a few statistical aggregation functions, such as average, variance, and standard deviation. Other typical statistical calculations require you to write longer DAX expressions. Excel, from this point of view, has a much richer language. The Statistical Patterns are a collection of common statistical calculations: median, mode, moving average, percentile, and quartile. » Read more
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/stdevx-p-function-dax