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 worked! Could you please share with me how you adjusted it? I tried to follow your formula in the file I sent you, but it still did not work 😞
Is it because my power BI set something up differently?
Best,
K.
My bad! I think I know what you mean now!!! At first, I thought you want me to change from "Dont Summarize" to "Sum" in the model part. I just changed it in the visualization and it works now. Thank you so so much for being patient with me and help me until I figure this out!!!
😄 all good! Glad you got it!