Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

RANKX ISSUES

I have been trying to iron out this issue for a week now.  I saw in tutorials that if you use ALL in your RANKX formula that the Rank result would not be "Ones".  I have done so in the below example ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    Or with this

     

    Ranking =
RANKX (
    SUMMARIZE (
        ALLSELECTED ( 'WMGBU BEx Query' ),
        'WMGBU BEx Query'[ENT BASE ITEM],
        'WMGBU BEx Query'[profit center]
    ),
    CALCULATE ( SUM ( 'WMGBU BEx Query'[DIRECT MARGIN (PROJECTED)] ) )
        / CALCULATE ( SUM ( 'WMGBU BEx Query'[REVENUE (PROJECTED)] ) )
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Alas this tells me everything that I have completed already.  I have the rank appearing correctly now...my issue is if I want to add a profit center to the table (not a filter) the rank changes to by profit center as well.  I need the rank regardless of the profit center which this thread does not address.

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Anonymous

     

    Try with

     

    Ranking =
RANKX (
    ALL ( 'WMGBU BEx Query'[ENT BASE ITEM], 'WMGBU BEx Query'[profit center] ),
    CALCULATE ( SUM ( 'WMGBU BEx Query'[DIRECT MARGIN (PROJECTED)] ) )
        / CALCULATE ( SUM ( 'WMGBU BEx Query'[REVENUE (PROJECTED)] ) )
)
    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      8 years ago

      Anonymous

       

      Or with this

       

      Ranking =
RANKX (
    SUMMARIZE (
        ALLSELECTED ( 'WMGBU BEx Query' ),
        'WMGBU BEx Query'[ENT BASE ITEM],
        'WMGBU BEx Query'[profit center]
    ),
    CALCULATE ( SUM ( 'WMGBU BEx Query'[DIRECT MARGIN (PROJECTED)] ) )
        / CALCULATE ( SUM ( 'WMGBU BEx Query'[REVENUE (PROJECTED)] ) )
)
      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        This one worked perfectly...thx so much for your time and efforts!