Percentile calculations in DAX

  • a.abalos.castillo

    Mr or Mrs. 500

    Points: 559

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

  • davidmitchell85

    SSC Enthusiast

    Points: 163


    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....



    ( 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.


  • a.abalos.castillo

    Mr or Mrs. 500

    Points: 559

    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.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply