Hello, i have a simple table with categories and revenue its earning . I wanted to compare side by side diffrences in revenue in other date ranges to see if there are any trends. So to do that i used alternate states and it works fine. Problem is starting when im trying to use any filter. It only applies to default state measure unless i do three of those filters each assigned to diffrent state. I would like to use one filter that aplies to all states.
I have seen in other topic solution like this :
sum ({ [Group 1]<Brand=$::Brand> } Sales)
But then only the brand filter works on all alternate states.
Sounds like you should be using the inverse direction - all your formulas should be associated with the default state and only the date selection should be passed from the alternative states (using the same method as you posted above).
