I recently needed to use create a DAX Measure that would return the Percentile of my serie but hit a wall as the percentile function was nowhere to be seen.
MINX(FILTER(VALUES(MyDataSerie1[Col1]), CALCULATE(COUNTROWS(MyDataSerie1), MyDataSerie1[Col1] <= EARLIER(MyDataSerie1[Col1]) ) > COUNTROWS(MyDataSerie1)*0.9), MyDataSerie1[Col1])
It's working quite well so far but it is just so frustrating to use such a complex template for something that seems so common.
Have I missed a function that would allow me to compute quantiles easily ? Do you have other suggestions ?
The pattern described in this article should work with both odd and even data sets: