Forum Discussion
RANKX Returning False Ties
The problem appears to be that the Client Rank measure is using the rows of the 'Client Data' table as a basis for the ranking, rather than the distinct Customer Codes.
The result is that any client whose [Total Client Rev] is at least as large as the largest [Total Client Rev] revenue evaluated in the row context of any individual row of 'Client Data' will be ranked 1, and so on.
If you adjust your measure as follows, it should give you sensible ranks:
Client Rank = RANKX ( ALL ( 'Client Data'[Customer Code] ), [Total Client Rev],, DESC )
Regards,
Owen
Super UserThe problem appears to be that the Client Rank measure is using the rows of the 'Client Data' table as a basis for the ranking, rather than the distinct Customer Codes.
The result is that any client whose [Total Client Rev] is at least as large as the largest [Total Client Rev] revenue evaluated in the row context of any individual row of 'Client Data' will be ranked 1, and so on.
If you adjust your measure as follows, it should give you sensible ranks:
Client Rank = RANKX ( ALL ( 'Client Data'[Customer Code] ), [Total Client Rev],, DESC )
Regards,
Owen
This worked perfectly. Thanks so much. I'll keep in mind that I need to be column specific for these RANKX files.