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.

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.