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
        )
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.