Forum Discussion
Question on RANKX formula and selected value
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]))
)
Apologies, you do need the calculate:
RANKX(
ALL(migrationt[Name]),
CALCULATE(SUM(migration[netflow_tot]))
)
Does it work with the calculate?
Can you share the pbix with sample data?
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
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.
Yeah, that doesnt help much 😛
Am i correct to assume, that there are distinct states 50 in your data?