I am trying to apply a filter, which only applies to my secondary datasource on a worksheet, and it does not seem to be working. I have a dimension common to both datasources on my worksheet and the relationship is definied with for this dimension. Then I have a metric from the first datasource, and another metric from the second datasource. I want to filter the metric from the second datasource on a dimension that is unique to that second datasource, and all my data disappears when I apply the filter. If I change my secondary datasource to primary, I can filter on it. However, it is not showing all the values from the dimension that I would like it to show since it is being filtered on.