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: "insufficient memory, try it later".

And I need this formula in others. So I don't know how to do to show that value.

Thanks a lot

Greetings.

3 Replies

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