The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
)
User | Count |
---|---|
26 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
30 | |
15 | |
12 | |
12 | |
7 |