Forum Discussion
Problems with Rankx skipping numbers
Super User"I am fairly new to Power Bi and I am not a programmer" - yeah, but you have chosen a really hard problem to start your journey. I would recommend you make extensive use of variables and CONCATENATEX to troubleshoot and debug every single step in your very complex calculation. Probably a slipped filter context somewhere.
Also - please don't use a line to connect city data. Lines suggest correlation, and there simply is none in that data.
lbendlin Thank you so much for assisting me. I used the CONCATENATEX to look at the formula for the average, and it appears that it is using the correct values for each city by month. I am not sure where to go from here.
The Rank, however, is doubling when the population doesn't have the same number each month.
Also--I am not understanding what you mean by "please don't use a line to connect city data. Lines suggest correlation, and there simply is none in that data"--can you please explain more?
Thank you so much for your response.