Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Calculation percentile range

Good morning, I'm trying to calculate the percentile range of a formula (attached photo). But when I put it in a table to show it I am not able to show me the values and I get an error message: "insu...
amitchandak's avatar
amitchandak
Super User
4 years ago

Syndicate_Admin , Any reason for giving 4 in third parameter, Can that be blank?

 

Also, do you want this formula at row level?

 

You can choose some level like the example

 

rankx(allselected(Table[ID]), [Measure] )

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Good, I'm trying to pass this formula from excel to the DAX language:

RANK. PERCENTILE(Continuidad_A_sbir_hora_2;4)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Syndicate_Admin ,

     

    I suggest you to add an [Index] column in Power Query and then calculate the percentile rank.

    Measure:

    Percentile Rank = 
VAR _Running_Total =
    CALCULATE (
        SUM ( 'Table'[Score] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Index] <= MAX ( 'Table'[Index] ) )
    )
VAR _TOTAL =
    CALCULATE ( SUM ( 'Table'[Score] ), ALL ( 'Table' ) )
RETURN
    DIVIDE ( _Running_Total, _TOTAL )

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.