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

1/23/2024

6780

pas

7

6/1/2024

4567

Das

5

6/3/024

 this is the sample table.

i tried this formula  

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

it giving me uneven graph, rather than staright line for the  95th percentile value.TIA

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.

3 Replies

  • Shravan133's avatar
    Shravan133
    Icon for Super User rankSuper User
    2 years ago

    Ypur measure looks okay to me. 

    If you are seeing uneven graphs or a non-constant line, ensure that:

    • Context: The measure should be used in a visual where the context is set correctly. For example, if you're using a line graph, make sure the X-axis has a constant value or a relevant time dimension.

    • Data Aggregation: Verify that the visual is aggregating the data in a way that aligns with the percentile measure. For instance, if the graph is showing data points over time or by team, ensure the percentile measure is plotted correctly.

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