Forum Discussion

Sid10's avatar
Sid10
Helper I
5 years ago
Solved

Calculating Percentile using Rank and Count

We know that Percentile = Rank/(n+1), where n is the number of values for which the percentiles are being calculated.  This has worked fine for me in powerbi when the values are distinct. However, i...
Need Help
  • mwegener's avatar
    mwegener
    5 years ago

    Hi Sid10 ,

     

    try this.

     

    LowBirthWt_%ile = DIVIDE([LowBirthWt_Rank], COUNTX(ALL(CQM), CQM[GrantNumber]))

     

mwegener's avatar
mwegener
Most Valuable Professional
5 years ago

Hi Sid10 ,

 

try this.

 

LowBirthWt_%ile = DIVIDE([LowBirthWt_Rank], COUNTX(ALL(CQM), CQM[GrantNumber]))

 

Sid10's avatar
Sid10
Helper I
5 years ago

Wow! That did it! Thanks a lot.

Just a minor correction. Your formula should be:

LowBirthWt_%ile = DIVIDE([LowBirthWt_Rank],COUNTX(ALL(CQM),CQM[GrantNumber])+1)

 

  • Tahreem24's avatar
    Tahreem24
    Super User
    5 years ago

    I am sorry Sid10 just got time to see your post.

    It's great mwegener has already resolved your issue.