Problem with RANKX with certain condition

[AntrikshSharma]

@Toni This:

RANKX displaying duplicate rank despite different quantities

@_mk7 RANKX has to build a lookup table internally using the table supplied in the first argument plus the measure used for ranking and then evaluates the same measure in the filter context, now lookup table will have a lower value for each row while the measure evaluated in the filter context will have a higher value due to the granularity at which both are evaluated, since you are only using one column of that table in the visual so there is a granularity mismatch between RANKX and the Matrix…