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

Definitely! though I am not sure if it would be much help here. I compile everything in just one table, so there is no relationship between the datasets at all (please see the attached).

 

Can you think of any other places that the error could occur?

 

Best,

K.

Tutu_in_YYC's avatar
Tutu_in_YYC
Super User
1 year ago

Yeah, that doesnt help much 😛

Am i correct to assume, that there are distinct states 50 in your data?