Measures to calculate percentile

[Geraldtanwx199_]

can someone help me? 
I am using field and number parameters to do the attached graph.

But for my table, I want to calculate the number of students within the "x" percentile.

what are the easiest way to do way to do it? 

my dataset is from: Students Exam Scores: Extended Dataset
Thanks for the help!

[Geraldtanwx199_]

 

Hello,

i am using the attached graph to show percentile.

is there a way to sum the total count of student under "x" percentile? i have been trying but my count of student is always at 31K.

Thanks in advance!

[v-tsaipranay]

Hi @Geraldtanwx199_ ,

Thank you for reaching out to the Microsoft Fabric Community.

I wanted to check if you had the opportunity to review the information provided by @ltripathi . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[ltripathi · Accepted solution]

Hi @Geraldtanwx199_ ,

You can try making two measure
1. create a measure to calculate the percentile value for the selected percentile

PercentileValue =

PERCENTILEX.INC(

    ALL(Expanded_data),

    Expanded_data[WritingScore],

    SELECTEDVALUE(Parameter[Parameter])

)

and 
2.create a measure to count the number of students whose scores are below the calculated percentile value

CountBelowPercentile =

CALCULATE(

    COUNTROWS(Expanded_data),

    FILTER(

        ALL(Expanded_data),

        Expanded_data[WritingScore] <= [PercentileValue]

    )

)