Creating a filtered measure from another measure

You can create custom measure that copies an existing measure and adds a filter.

Note: You cannot base a filtered measure on a custom measure or a numeric type measure.

1. Select the More menu for the custom measure you want to add the custom filter to and select Create filtered measure.
2. In the Name text box, specify a name other than the default name. The name appears in the field picker and in the data table.
3. In the Filters tab, select the field that you want to filter by from the Filter name drop-down list.
4. Select the existing condition button, which by default is any value, under Filter value to customize the filter conditions that you want to apply.
5. Select the condition, and enter or select a value.

   To save the value, click outside the filter condition, or use the escape key.

   • When available, value suggestions will appear in a drop-down list, which is indicated with a downward-facing arrow in the value input box, for users to select or search against. Suggestions are most commonly available for string fields.
   • If you're editing an existing custom measure, consider changing the custom measure's name to reflect the filter condition.
6. To add more filters, select the Add plus sign button in the Filter value section; to remove filters select the Remove minus sign button.
7. Click the down arrow next to Custom filter at the bottom of the Filters tab to expand the Expression text box to add a custom filter instead of or in addition to a UI-based filter. Enter an expression in the Custom filter box using any functions and operators that can be used in custom filters. The expression editor will suggest field names and display syntax help for any functions you use. Fields that are both currently used and eligible to be used with the field type that you're creating are marked with a black circle.
8. To select a format for the custom measure, select the Field details tab and then select the format option from the Format drop-down list.
9. Click Save.

The new measure is displayed in the Custom Fields section in the field picker.

Parent topic: Using custom fields

Related information

• Functions and operators