We have a dataset using a star schema, which is used as a data source for several reports. This works fine, however one issue we have is that a couple of dimension tables have thousands of entries, so the filters on those are rather inconvenient to use.
So I looked into a couple of options to reduce the fields by only keeping the ones whose keys are present in the fact table. One option that seemed feasible, is to create a filtered copy of the dimension table (via CALCULATETABLE(Dimension, Fact)) and then create a 1-1 relationship between both, using the filtered copy to filter. This works when tested in a report within the dataset file itself.
When importing the published dataset for use in another report however, the relationship between the dimension table and the filtered calculated table does not show up and the filter therefore won't work. What could be the reason of this?
