RANKX - inconsistent ranking

[Marcus_swe]

Hi, I am new to the PowerBi world, mostly fun but i have been stuck on this issue for some time now.

I can't figure out why i can't get the RANKX function to work.

I want to summarize all the sales done by Sales Person ID and then rank the top 15 salespersons. 

When i try to rank the Sales ID by the total amount of sales i get an inconsistent ranking. 

• Why do i get this inconsistent ranking and how can i fix it?

Tried different YouTube-guides but can figure out what the issue is. 

I have a huge Excel-file containing loads of data. But for what i want to achieve i only need two columns (I think) from the excel file. I have created an example from fake data down below. 

Note that the sales data excel file is roughly 2500 rows. 

[Marcus_swe]

@Anonymous Thank you for the links, they gave me alot better understanding! 

@v-cherch-msft Worked like a charm, together with the other information i have recoved i should be able to sort things out now! 

@mussaenda Cant understand why i didnt find that youtube clip by my selfe, it was more or less exactly what i was looking for! 

I am verry greatful for your help!!

BR Marcus

[mussaenda]

You may want to watch this tutorial re rankx

[v-cherch-msft · Accepted solution]

Hi @Marcus_swe 

You may use below measure:

Ranking by sales =
RANKX (
    ALL ( Table1[Sales Person ID] ),
    CALCULATE ( SUM ( Table1[Sales] ) ),
    ,
    DESC,
    DENSE
)

Regards,

[Anonymous]

Hi @Marcus_swe ,

Please follow this link.

1.

http://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns

2.

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=f71b4800-...

Revert me back if any doubt.

Best Regards,

Ravi