Returns the k-th (inclusive) percentile of an expression values in a table.
Table over which the Expression will be evaluated.
Expression to evaluate for each row of the table.
Desired percentile value in the interval [0,1].
Learn more about PERCENTILEX.INC 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/percentilex-inc-function-dax