Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi,
I wanted to assign a rank to attainment on a table, attainment was created using the DAX expression. When I use the rank function
Team Mapping relation - table
Attainment% - Dax function
Rank in Descending
Solved! Go to Solution.
Hi @Sri_phani
Please try
Rank =
RANKX (
ALLSELECTED ( 'Team mapping relation'[Remitly ID] ),
[Attainment %],
,
DESC,
DENSE
)
@tamerj1 I just need small help, I need to apply conditional format the text column (attainment) which was created using DAX.
I found this online, I guess this is wrong, can you please help me to apply formatting to DAX column
This is second time you are helping me on a day. Thank you very much.
Hi @Sri_phani
Please try
Rank =
RANKX (
ALLSELECTED ( 'Team mapping relation'[Remitly ID] ),
[Attainment %],
,
DESC,
DENSE
)
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
7 | |
5 | |
4 | |
3 |
User | Count |
---|---|
12 | |
11 | |
10 | |
9 | |
8 |