Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
Trying to create a simple ranking based on Gross Profit (Measure) Sadly couldn't get it working. Tried using Gross Pay (Column) pretty much the same result. If i remove the empName from the ALL SELECTED line then it will show some kind of ranking but not in order 1-2-3-4 etc it will show 1-8-24 etc. Any help or guidance would be apprciated, already read through a few posts and watched the video below
Hi,
The title of the column is Employee Name but you are referring to EmpName in your formula. Could that be the reason? Also, ensure that you write this as a measure (not a calculated column formula).
Measure = RANKX(ALL(Test),CALCULATE(SUM(Test[GrossPay])))
@Anonymous
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
96 | |
89 | |
73 | |
61 | |
58 |