Forum Discussion

GWoodhouse's avatar
GWoodhouse
New Member
3 years ago
Solved

Problems with DAX RankX

I have a table containing Country names and Priority Orders Country Priority UK          1 US          1 NL          2   and another table containing a measure that sums a value What I want is...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi GWoodhouse 

    try like:

    Country Rank =
    Rankx(
            all(Country[CountryName]),
            CALCULATE[MySumMeasure], ALL(Country[Priority]),
            ,desc
            ,Dense
        )
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi GWoodhouse 

try like:

Country Rank =
Rankx(
        all(Country[CountryName]),
        CALCULATE[MySumMeasure], ALL(Country[Priority]),
        ,desc
        ,Dense
    )
GWoodhouse's avatar
GWoodhouse
New Member
3 years ago

PERFECT!

Now please explain why that works 😉

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    [MySumMeasure], as a measure, has an implicit CALCULATE, which converts the row context - Priority, to filter context.