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

     

     

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

Hi， TMoney 

Add a new measure like:

New Rank basic =
VAR tab =
    ADDCOLUMNS (
        'aims teams',
        "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