Forum Discussion

srimathyKarthik's avatar
srimathyKarthik
New Member
2 years ago
Solved

Calculating 95th percentile

Hai, I want to calculate the 95th percentile for the transfercount data that is on june month and for the year 2024 TeamID TeamName TransferCount IncidentDate 3457 Sas 6 ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi srimathyKarthik 

     

    Thanks for the reply from Shravan133.

     

    Here is my testing for your reference:

     

    Sample data:

     

    Modify the measure as follows:

    95% = CALCULATE(
PERCENTILE.EXC(Query1[TransferCount], 0.95),
FILTER(
ALL(Query1),
MONTH(Query1[IncidentDate]) = 6 && YEAR(Query1[IncidentDate]) = 2024
    )
)

     

    Output:

     

    Best Regards,
    Yulia Xu

     

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

srimathyKarthik's avatar
srimathyKarthik
New Member
2 years ago

95th percentile vlaue i tried to put it in a table to see the value it shows 17, but it not able to visualise as a percentile

line

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi srimathyKarthik 

 

Thanks for the reply from Shravan133.

 

Here is my testing for your reference:

 

Sample data:

 

Modify the measure as follows:

95% = CALCULATE(
PERCENTILE.EXC(Query1[TransferCount], 0.95),
FILTER(
ALL(Query1),
MONTH(Query1[IncidentDate]) = 6 && YEAR(Query1[IncidentDate]) = 2024
    )
)

 

Output:

 

Best Regards,
Yulia Xu

 

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