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 skips unused rank numbers. See screenshot below, where the table on the left omits the geograhic location, and the table on the right includes it.
Generically, the rank and ranked measure look like this:
% RANK =
RANKX (
ALLSELECTED ( 'Dimension'[Item] ),
CALCULATE ( [% Measure], ALLEXCEPT ( 'Dimension', 'Dimension'[Item] ) )
)
% Measure =
DIVIDE (
SUM ( 'FACT_1'[COLUMN_1] ),
SUM ( 'FACT_2'[COLUMN_2] ),
BLANK()
)
Am I missing something to control for the additional category added to the visual? My understanding is that this should only come into play if I wanted to rank within each category, but this rank measure is independent of the category.
NOTE: I'm trying to replicate within a dummy dataset to share but have not been successful yet.
- Anonymous5 years ago
Resolved this with the updated measure:
% RANK =
RANKX (
ALL ( 'Dimension' ),
CALCULATE ( [% Measure], ALLEXCEPT ( 'Dimension', 'Dimension'[Item], 'Dimension'[Category]) )
)
1 Reply
- AnonymousNot applicable
Resolved this with the updated measure:
% RANK =
RANKX (
ALL ( 'Dimension' ),
CALCULATE ( [% Measure], ALLEXCEPT ( 'Dimension', 'Dimension'[Item], 'Dimension'[Category]) )
)