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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
)