Post reply

Percentile calculations in DAX

  • April 27, 2014 at 11:22 pm

    #396666

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

  • 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

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

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

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