There is a model where a concatenate was done between the fact tables into a single table. Because of this, a certain filter can reset data that is not related to the same fact.
Example: * Order Fact: Order number, order date, customer code, store code, employee code, item code, quantity, total price, discount flag. * Target Fact: Date, employee code, target. When a store is selected, all targets are reset.
I want to create a measure and add Set Analysis to ignore all selections, except for selections made in two tables – Calendar and another table (by specific fact). I don’t want to specify all the fields, but rather reference the entire table, as fields might be added over time.
