Percentile calculations in DAX

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

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



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


  • 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 2 (of 2 total)

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