Forum Discussion
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...
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]))
)
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.
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