Calculating Percentile in MDX

The MDX function is available for median . Percentile is not directly supported yet, looks like a good idea to add, but we can use the vector MDX + function using the percentile object function .

Vector( [Set] , [Value], EXCLUDEEMPTY )->percentile(50)   // for the median

      

        
        
        
      

    

the same as

Median( [Set] , [Value] )

      

        
        
        
      

    

---

If you want to do it straight from the measure (level of fact). There is a list of aggregation methods that return a vector. Let's say we have defined a measure [P & L Vector] using the Vector aggregation method. Then for the median it will be:

[P&L Vector]->percentile(50)

      

        
        
        
      

    

---

From the next version 6.2 there will be an MDX function to support Percentile:

 Percentile( [Set], [Value] , 95 )