Measure criteria let you filter Members by evaluating a Measure’s value for each of the Members, comparing the values to another specified value and deciding whether the Member fits the specified condition.

 

Examples:
- Filter customers whose sales (Measure) is greater than their cost (Measure)
- Filter products for which sales (Measure) is greater than zero
- Filter stores for which sales are greater than their cost in January 2008.

 

Comparing a Measure to an explicit numeric value

 

Comparing a Measure to another Measure

 

Component	Description
1	The Measure to compare (click to change selection)
2	The comparison operator to use (click to change selection)
3	The number or Measure to compare to
4	Switch between ‘Compare to Numeric Value’ and ‘Measured Value’ modes
5	The Measure’s background (click to modify)
6	Add another criteria with an AND/OR logical operator

 

The Measure's Background

It is possible to restrict the calculation of the Measure’s value to the scope of specified Members.  This allows you to filter Members whose Sales in May-2008 are greater than some value.

To define the background (scope) of the Measure, click on the box titled ‘Click to define background’, navigate to the relevant Dimensions and select the Members or Filters to use.

See Also