Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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.  

  • Anonymous's avatar
    Anonymous
    5 years ago

    Resolved this with the updated measure:

     

    % RANK = 

    RANKX (
        ALL ( 'Dimension' ),
        CALCULATE ( [% Measure], ALLEXCEPT ( 'Dimension', 'Dimension'[Item], 'Dimension'[Category]) )
    )

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Resolved this with the updated measure:

     

    % RANK = 

    RANKX (
        ALL ( 'Dimension' ),
        CALCULATE ( [% Measure], ALLEXCEPT ( 'Dimension', 'Dimension'[Item], 'Dimension'[Category]) )
    )