Forum Discussion

rajivraina's avatar
rajivraina
Helper II
7 years ago

Ranking data across multiple categories within same column

Hi,   I have a table of data that has macroeconomic data on countries over a period of years. I am trying to assign a rank to each country based on their value, while still taking into account the ...
Need Help
rajivraina's avatar
rajivraina
Helper II
7 years ago
Zubair_Muhammad wrote:

rajivraina 

 

Try this MEASURE.

See the attached file as well with your sample data

 

Measure =
RANKX (
    CALCULATETABLE (
        Table1,
        ALLEXCEPT ( Table1, Table1[ Grouping ], Table1[ Indicator ], Table1[ Year ] )
    ),
    CALCULATE ( SUM ( Table1[ Value ] ) ),
    ,
    DESC,
    DENSE
)

Zubair_Muhammad This is the result for me...it looks like it is ranking correctly according to the value but it is not taking into account Year or Grouping or Indicator. The highest rank should be around 200-300 as that is the max # of countries. Any idea what's going on?

 

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago
Could you share file or full data
  • rajivraina's avatar
    rajivraina
    Helper II
    7 years ago

    Zubair_Muhammad Can I send you the file in a private message? If not, I can post here but would rather avoid that.

     

    Thanks,

     

    -Raj