Forum Discussion

kobkabnaja's avatar
kobkabnaja
Helper II
1 year ago
Solved

Question on RANKX formula and selected value

Hi community,   I have a question about RANKX formula. I am using it to rank states based on net population inflow. The formula I used is shown below, and the results appear to be correct (see atta...
Need Help
  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    1 year ago

    Anonymous is correct. These 2 have "Dont Summarize", and it is parsing out the states further.


    If you remove them, or change them to sum or a different aggregation, Rank would work again using:

    RANKX(
        ALL(migrationt[Name]),
        CALCULATE(SUM(migration[netflow_tot]))
    )

     

Tutu_in_YYC's avatar
Tutu_in_YYC
Super User
1 year ago

Try this..

*edited to add Calculate in orange

RANKX(
    ALL(migrationt[Name]),
    CALCULATE(SUM(migration[netflow_tot]))
)
  • kobkabnaja's avatar
    kobkabnaja
    Helper II
    1 year ago

    Hi Tutu_in_YYC ,

    Thanks for your prompt response. I did try that formula. But it did solve the problem. When I selected only one state, it still showed rank 1.

     

    I would appreciate any further suggestions you may have.

     

    Best,

    K.

    • Tutu_in_YYC's avatar
      Tutu_in_YYC
      Super User
      1 year ago

      interesting... we tried on my end, and it works... see below:


      after selection

       

       

      • kobkabnaja's avatar
        kobkabnaja
        Helper II
        1 year ago

        Thanks for your comfirmation. I tried both [YEAR], and [STATE] (or NAME) in the ALL('migration'[Name]). Both give me inccorect values, either 1 or 50. And when I took the CALCULATE out, all the values beccame 1 (I did not show it in the attached).

         

        I am wondering if there is something that I have to do with the year filter.

         

        Thank you,

        K.