Initiating Measure Filters

Measure filter is accessible through the context menu when you right-click on measure column header. To apply a measure filter, ensure all the positions you have selected in wizard are available on the pivot table. Measure filtering is enabled when you place the measure dimension tile on x-axis and one of the position dimension tile on y-axis, with the remaining position dimension to be placed on z-axis. Measure filters function by filtering the positions of the dimension on the row axis.

Note:

A measure filter is applied only on the measure dimension, meaning that the measure filter option is not available on other position dimensions.

After applying filters, if you move the placement of the measure dimension or position dimension then the applied filters will be reset.