Forum Discussion
Problem with simple rankx
| 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?
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.
3 Replies
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
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
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.
