Forum Discussion

rhl94's avatar
rhl94
Advocate 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

rhl94's avatar
rhl94
Advocate III
6 years ago

Unfortunately that does not seem to work:

The Rank column is the desired outcome.

 

az38's avatar
az38
Community 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