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

     

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