I'm using a filter with multiple values in one of my dashboards. Let's say that the dimensions are Standing portfolio A, Standing portfolio B and Pipeline. For the standing portfolio's I know al my data, but for the pipeline some data is missing for specific measures. Therefore, I want to change some measures in my worksheets to "n/a" if Pipeline is selected in one of the possible combinations in my filter with multiple values.
Does someone knows how to solve this? Thanks in advance!