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 

It might be related to the formula of [SUM.$CFLV Sales].
Please provide a sample pbix for further research.

 

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