So I'm doing some comparative analysis using Alternate States. My issue is I have two different dimensions that I want to be able to make selections on that affect both states. So I've been using the following expressions: MEDIAN({[AltState] <Region= $::Region, Date = $::Date > } Sales). The issue that I am running into now is only calculates the Sales median where Region and Sales is not null, however I would like it to look at all values of Region and Date when there is no selection made.
