Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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
Read about the PERCENTILE and PERCENTILEX functions in DAX. Bottom quartile would be .25 .
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
82 | |
78 | |
52 | |
39 | |
35 |
User | Count |
---|---|
94 | |
79 | |
51 | |
47 | |
47 |