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...
I had the same problem and while KingKong333 your solution works, it creates a lot of problems with filtering/shaping your data, because you're mixing text and numeric values. Here's a simple modification that prevents this:
= if(count(tableName[columnName])>99,PERCENTILEX.EXC(Query, tableName[columnName],0.98),BLANK())
or if you just want simple percentiles without a query:
= if(count(tableName[columnName])>99,PERCENTILE.EXC(tableName[columnName],0.98),BLANK())
The condition in the if statement should check whether count is large enough to calculate the percentile you want. E.g. if you want 90th percentile, it needs to be >9, whereas for 75th it would be >3, etc.