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

It does not. The rank showed only the first (1) and the last (50). Amazingly, when I tried to create a sample data and used your code, it worked well!!! This is so confusing to me. Do you have any other ideas why this happened?

Thank you,

K.

Tutu_in_YYC's avatar
Tutu_in_YYC
Super User
1 year ago

I tried to replicate your error, but no dice. Can you share a screenshot of your model view? Maybe theres something we can identify in there

  • 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?

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