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]))