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