Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
96 | |
84 | |
70 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |