Calculating 95th percentile

[srimathyKarthik]

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

[srimathyKarthik]

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 · Accepted solution]

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]

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.