

These marks cannot be filtered out or hidden because the NULL mark on one axis is associated with all of the non-NULL marks on the other axis.īlend in a second copy of the original data source, and then use the measure(s) to be filtered from the secondary data source as well as the filter field(s). Note: When using a parameter, each axis may have one NULL mark. See Creating a Calculation that Ignores Filters for directions either using the level of detail (LOD) expression FIXED, or a parameter. Option 1: Create a calculation that ignores filtersĬreate a calculation that ignores filters to use as one of the axes. The workbook downloadable from the right-hand pane provides examples for each option with detailed instructions.

See Additional Information below for more details on when each solution may be a better option when. Depending on the view, the best option will vary.
