Forum Discussion
90th Percentile Issues (Not displaying correctly)
Hi CPage-WF ,
You can try to write the result you want in Dax, i have created an example below:PERCENTILE.EXC = VAR _1 = ISO.CEILING( COUNTAX ( 'Public-Dashboard', 'Public-Dashboard'[Index] ) * 0.9, 1 ) RETURN CALCULATE ( SUM ( 'Public-Dashboard'[Unit Turnout Time] ), 'Public-Dashboard'[Index] = _1 )Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi CPage-WF ,
Based on the information you provided, the function returns an incorrect result because it returns a value with a decimal instead of the 21st or 20th digit.
You can use the ROUND function to round the result of the PERCENTILE.EXC function to an integer. This way, you get an integer result.
PERCENTILE.EXC =
ROUND ( PERCENTILE.EXC ( 'Public-Dashboard'[Unit Turnout Time], 0.9 ), 0 )
Or you can write your own dax to calculate the result:
Measure =
VAR _1 =
ROUND ( COUNTAX ( 'Public-Dashboard', 'Public-Dashboard'[Index] ) * 0.9, 0 )
RETURN
CALCULATE (
SUM ( 'Public-Dashboard'[Unit Turnout Time] ),
'Public-Dashboard'[Index] = _1
)
Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous - While I was very hopeful that this would work, it seems to still return the wrong value. See below, in this specific data set there are a total of 19 calls so 19 * 0.9 = 17.1 so it should show the 18th value at 77 but instead it is showing 75. I am not sure where it is getting this odd value from.
I am not sure how to explain the data that is in the able. See below as each unit has a different turnout time for each incident
Hi CPage-WF ,
You can try to write the result you want in Dax, i have created an example below:PERCENTILE.EXC = VAR _1 = ISO.CEILING( COUNTAX ( 'Public-Dashboard', 'Public-Dashboard'[Index] ) * 0.9, 1 ) RETURN CALCULATE ( SUM ( 'Public-Dashboard'[Unit Turnout Time] ), 'Public-Dashboard'[Index] = _1 )Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.