Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
James13
Frequent Visitor

Bottom Quartile Management

How can i posible identify the top midtop midbottom and bottom.
they will be dort from highest to lowest
then after that i would divide the lets say the headcount to 4 then distribute the top midtop midbottom and bottom
for example the headcount is 20, so 20/4 = 5, so the top midtop midbottom and bottom will be distributed bse on the sorting highest to lowest 
Also my Score is a measure because i wanted it to be dynamic 


for example this is the visualization i want 
personID | score
-----------|-------
A1 | 300   bottom
A2 | 320   bottom
A3 | 250   bottom
A4 | 310   midbottom 
A5 | 240  midbottom 
A6 | 250  midbottom 
A7 | 260  midtop 
A8 | 270  midtop 
A9 | 240  midtop 

A10 | 240  top 

A11 | 240  top 

A12 | 240  top 

Im really stuck with this problem. I badly need help. Thanks in advance

1 REPLY 1
lbendlin
Super User
Super User

Read about the PERCENTILE and PERCENTILEX functions in DAX.  Bottom quartile would be .25  .

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.