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.
SalesPerson | Sales | Measure Rankx |
Jonh | 100 | 1 |
Mary | 80 | 2 |
Tom | 80 | 3 |
Eli | 70 | 4 |
Clark | 50 | 5 |
Anne | 40 | 6 |
I wanna make a simple RANKX but I'm having some problems, my RANKX is the following:
Measure RANKX = RANKX(ALLSELECTED(BI_Sales[SalesPerson]); [Sum_Sales]))
Sum_Sales = SUM(BI_Sales[Sales])
I have done a simple RANK like this in other projects and it works.
Someone knows what can cause it?
Solved! Go to Solution.
Hi,
If you are wondering why the rank is the same, it is probably because there are decimal numbers in the sales figures. Check your source data.
Hi,
If you are wondering why the rank is the same, it is probably because there are decimal numbers in the sales figures. Check your source data.
Not Sure , I for the issue completely. Given all or table name instead of all selected
Measure RANKX = RANKX(ALL(BI_Sales[SalesPerson]); [Sum_Sales]))
Measure RANKX = RANKX((BI_Sales); [Sum_Sales]))
Refer for rank
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
I'm not sure what problem you are having. Did you want the ranking to be tied between the 2 that have the same sales? I'm pretty sure that you can specify the ties portion of a rankx measure with Dense or Skip
so the measure would look like..... Rankx(all selected(table); [measure],,dense))
I'm pretty sure that dense is the one that would give you 2 Rank 2's but I'd try both options and see what's better
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |