Forum Discussion

rhl94's avatar
rhl94
Icon for Advocate III rankAdvocate III
6 years ago
Solved

Return a constructed column to MAX()

Hi   I'm looking to create a ranking as a measure.   It looks like the following:   RANKX(ALL(Corporate),CALCULATE(SUM(Corporate[Amount])),,ASC,Dense)   I'd like, in the measure, to divide t...
Need Help
  • az38's avatar
    az38
    6 years ago

    rhl94 

    what if try to use ALL()?

    DIVIDE (
    RANKX ( ALL ( Corporate ), CALCULATE ( SUM ( Corporate[Amount] ) ),  , ASC, DENSE ),
    MAXX (ALL ( Corporate ),     RANKX ( ALL ( Corporate ), CALCULATE ( SUM ( Corporate[Amount] ) ),  , ASC, DENSE ))
)

    do not hesitate to give a kudo to useful posts and mark solutions as solution

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi rhl94 

try MAXX function https://docs.microsoft.com/en-us/dax/maxx-function-dax , smth like

DIVIDE (
    RANKX ( ALL ( Corporate ), CALCULATE ( SUM ( Corporate[Amount] ) ),  , ASC, DENSE ),
    MAXX (Corporate,     RANKX ( ALL ( Corporate ), CALCULATE ( SUM ( Corporate[Amount] ) ),  , ASC, DENSE ))
)

do not hesitate to give a kudo to useful posts and mark solutions as solution

rhl94's avatar
rhl94
Icon for Advocate III rankAdvocate III
6 years ago

Unfortunately that does not seem to work:

The Rank column is the desired outcome.

 

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    rhl94 

    what if try to use ALL()?

    DIVIDE (
    RANKX ( ALL ( Corporate ), CALCULATE ( SUM ( Corporate[Amount] ) ),  , ASC, DENSE ),
    MAXX (ALL ( Corporate ),     RANKX ( ALL ( Corporate ), CALCULATE ( SUM ( Corporate[Amount] ) ),  , ASC, DENSE ))
)

    do not hesitate to give a kudo to useful posts and mark solutions as solution