Forum Discussion
Microsoft Employeepercentage value must be in range error
Hi dwbcz ,
According to the given information, the percentile value must be in the range of 1/(N+1)…N/(N+1) inclusive, where N is the number of data values. In your case, since you have only 3 data values, the range would be 1/4…3/4.
However, you mentioned that you want to get the 95th percentile value. Since the range of percentiles for 3 data values is limited to 1/4…3/4, it is not possible to obtain the 95th percentile value with only 3 data values.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi dwbcz ,
According to the given information, the percentile value must be in the range of 1/(N+1)…N/(N+1) inclusive, where N is the number of data values. In your case, since you have only 3 data values, the range would be 1/4…3/4.
However, you mentioned that you want to get the 95th percentile value. Since the range of percentiles for 3 data values is limited to 1/4…3/4, it is not possible to obtain the 95th percentile value with only 3 data values.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.