I have a drill down dimension State-City. The measure is average population.
Now I create different bookmarks with different states and cities selected. The average population of a State should not change based on the cities selected. For example, if Alabama has 20 cities and I choose 10 in the bookmark, then average for Alabama should for 20 cities not 10. But when I drill into Alabama, I need to see only 10 cities average. Need help with the expression.