Forum Discussion
Trouble with RankX
Objective: Have a column presenting the rank of customer based on total sales in descending order Data Format: What has not worked: Ranking = ...
parry2k
Super User
Super UserAnonymous here is dax expression as a measure, you can change asc or desc, based on your needs.
Rank = RANKX( ALL( Sheet1[Billing Company Name]), [Ext Price], , ASC)
Unfortunately still no dice:
Rank v3 = RANKX(ALL(Table_1046[Billing Company Name]), [Parts Sales], , DESC)
Produces:
It's all a rank of 1 except for the last few observations, which are negative values, and those are all rank 383.
Given that this doesn't seem to be working well this way, is there a way of using the TopN filter and generating a rank column from that? Thanks again for your help
Parts Sales is just:
Parts Sales = SUM(Table_1046[Extended Price])
- parry2k
Anonymous are you adding rank as a new column or measure? It should be measure.
attached file is create from your sample data.
Created as measure. It definitely works perfectly on your attachment. I'll do some more digging to see what could be interfering. Thanks again for your help. I really appreciate it