Percentile calculations in DAX

• a.abalos.castillo

  Mr or Mrs. 500

  Points: 559

  More actions

  April 27, 2014 at 11:22 pm

  #396666

  Comments posted to this topic are about the item Percentile calculations in DAX

• davidmitchell85

  SSC Enthusiast

  Points: 163

  More actions

  May 14, 2014 at 9:29 am

  #1713525

  Hi,

  Thanks for your article, I have followed it through and I think there may be a couple of typos in your formula....

  h25 - Should this read....

  =

  CALCULATE (

  ( COUNTROWS ( 'Measures' ) - 1 ) * 0.25 + 1,

  FILTER ( 'Measures', [FilterColumn] = [FilterCondition] )

  )

  x25up - Is this missing a MAXX function?

  I think that's all I picked up.

  I am still working through my data, so will post back once I am done.

  Thanks

• a.abalos.castillo

  Mr or Mrs. 500

  Points: 559

  More actions

  May 16, 2014 at 1:28 pm

  #1714325

  Thank you for your feedback! yes, you are right in both cases.

  I have updated the article and sent it for publishing. Hopefully, it will be corrected in 2-4 days.