Calculation percentile range

[Syndicate_Admin]

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.

[amitchandak]

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

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

RANK. PERCENTILE(Continuidad_A_sbir_hora_2;4)

[Anonymous]

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.