Forum Discussion
Issues with RANKX measure when adding additional dimension column
My rank measure works well when only introducing the ranked items, but when I introduce a category for each item (in this example, it's a geographic region) the rank measure returns false ties and sk...
Resolved this with the updated measure:
% RANK =
RANKX (
ALL ( 'Dimension' ),
CALCULATE ( [% Measure], ALLEXCEPT ( 'Dimension', 'Dimension'[Item], 'Dimension'[Category]) )
)
Resolved this with the updated measure:
% RANK =
RANKX (
ALL ( 'Dimension' ),
CALCULATE ( [% Measure], ALLEXCEPT ( 'Dimension', 'Dimension'[Item], 'Dimension'[Category]) )
)