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

Thanks for the response.  Your [New Rank Basic] measure makes sense (albeit I'm still confused as to why it's a necessary layer on top of RANKX).  In any event, it's still not working in my "real" file (I had redacted some info for purposes of posting the sample, but nothing that would seemingly impact results):

RANKX card not same as RANKX matrix - updated 

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?