Calculate Percentile in Power BI

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

[rstump]

I don't usually comment on videos but this was one of the best explanations I have found on rank and percentiles. It was exactly what I have been looking for. Thank you!!

[sankhlayashraj]

You are fantastic buddy... Thank you for sharing so much knowledge on PBI and PQ.

[bhakthasingh]

You are a master teacher, Chandeep! Shows how well you understood the subject and DAX.

[gdelena]

Wow, this is awesome. I'm building a comp analytics dashboard view and this pretty much covered all the elements that I want to show. Thank you!

[APG-ql]

Excelente tutorial. Enhorabuena. Muchísimas gracias.

[cpcdev]

Thank you so much! This is exactly what I was looking for. Not even AI could give me the answer I needed. :) Thank you again!!!!

[benbloisfilm]

You just earned yourself another subscriber

[estherwong]

Thank you for the video. How do you create the measure Salary Total

[andym-pbue]

Thank you, really well explained. I might be missing something, but I would have expected the top Teacher salary to be 100% in the occupation percentile column, but no-one is 100%?

[KgasS]

As usual good one. I think the denominator calculation can be shifted before return assigning to a variable as it will not vary for the filter context and may improve the performance.

[vineetyoutubr]

Very well explained 😊 thanks bro and keep up the good work to help people learn Power BI.

[shayhall]

what was your formula for [total salary] in the variable?

[baneledludlu]

wow! great one, thanks a lot man, God bless you!

[rstump]

This worked perfectly for me but I do have some percentiles that are tied. Is there a way to create a tie breaker? In my case it would be based on sales dollars instead of salary.

[rogeriodornellas]

Can I download this simple table data of Employee Salaries, to do the exercise? 😎

[bhaveshsavla]

Hi, you have explained superably. If i want to calculate percentile at occupational level what changes i have to make in the dax. Pls help.

[geetikakhurana]

Hi, can we calculate PercentRank in Power BI?

[Excel-Rn]

I have data of day wise sales entry for lots of items and multiple locations and i want to calculate periode wise percentile and location wise is it possible

[zeeshanmohiuddin]

If I want to add a percentile line to a line chart. Can I do this through analytics pane via adding percentile line or I have to use DAX to create a measure PERCENTILEX.INC() ??? Please let me know as I stuck somewhere and need to answer this question ASAP .. Thank you in advance

[MAbdullah]

What About doing it for the Sale Order Table? The order number and customer no will be duplicated, Please advice.