Hi, This is not the first time I am working with Percentile calculations in PBI. However within a report Percentile calculations seem to be working odd. The numbers are incorrect and also the for...
Here is the workaround I used:
= if(count([XXX])>99,PERCENTILEX.EXC(Query, [XXX],0.98),"")
This will show Blank if there are less then 100 items in the list, instead of throwing error.