topic Re: New to DAX & 90th Percentile in DAX Commands and Tips

New to DAX & 90th Percentile

todddonovan1969 — Tue, 04 Feb 2025 16:27:53 GMT

Hello, I'm new to DAX and I'm trying to create a visual looking at the 90th percentile. The Table is named Incident and the Column is named FirstArrivingChuteTime, I've attempted to use the help files, but it says it cannot display the visual matrix.

Any help would be appreciated!

Best,

Todd

Re: New to DAX & 90th Percentile

todddonovan1969 — Tue, 04 Feb 2025 16:40:33 GMT

Here is what I've written:

90th = PERCENTILE.EXC(Incident[FirstArrivingChuteTime], 0.9)

Re: New to DAX & 90th Percentile

todddonovan1969 — Tue, 04 Feb 2025 18:57:36 GMT

I figured it out! Persistance...

-Todd

Re: New to DAX & 90th Percentile

Anonymous — Wed, 05 Feb 2025 01:22:49 GMT

Hi todddonovan1969 ,

I'm glad to hear that you were able to resolve the problem! To help others who might face the same problem, could you please accept your solution as the correct answer? Thank you so much for your cooperation!

Best Regards,
Zhu