Forum Discussion

TMoney's avatar
TMoney
Frequent Visitor
3 years ago
Solved

Difference between RANKX in Matrix and Card visuals

Hello, I've reached out to two experts on this, and neither has been able to figure this one out.   I have a basic RANKX formula, ranking Sales: Rank Sales = RANKX ( ALL( 'aims teams' ), [SUM....
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, TMoney 

    I'm sorry for replying so late, I've just seen your message.

    Please checked the attached pbix file. You may need to modify the measure formula like:

    New Rank Basic = 
VAR tab =
    ADDCOLUMNS (
        ALLEXCEPT('aims teams','aims teams'[Index]),
        "SUM.$Sales", [SUM.$Sales],
        "_Rank basic", [Rank basic]
    )

RETURN
    MINX(tab, [_Rank basic] )

     

    Best Regards,
    Community Support Team _ Eason

     

     

TMoney's avatar
TMoney
Frequent Visitor
3 years ago

I was awaiting a further response to my question (sample file was attached which is still showing the error).  On top of trying to solve this particular challenge, I'm really interested in the underlying cause of why RANKX is behaving in this extremely unpredictable and strange way.

v-easonf-msft's avatar
v-easonf-msft
Community Support
3 years ago

Hi, TMoney 

I'm sorry for replying so late, I've just seen your message.

Please checked the attached pbix file. You may need to modify the measure formula like:

New Rank Basic = 
VAR tab =
    ADDCOLUMNS (
        ALLEXCEPT('aims teams','aims teams'[Index]),
        "SUM.$Sales", [SUM.$Sales],
        "_Rank basic", [Rank basic]
    )

RETURN
    MINX(tab, [_Rank basic] )

 

Best Regards,
Community Support Team _ Eason

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi! I'm having the same problem as the original poster but, when I try this measure in a visual, it keeps loading forever. Do you might know what can be causing this?