MicroStrategy ONE

Conditional metrics with multiple qualifications

Only one filter can be associated with a metric, but that one filter can contain as many filter qualifications as needed. For example, you need a report showing a count of customers with the following qualifications:

  • Female

  • Living in the Central region

  • Active customers

Create a filter with those three qualifications, apply the filter to the count metric, and add the metric to the report. The results are displayed below.

Report example with multiple qualifications on the conditional metrics

The metric definition looks the same as any other conditional metric; the multiple filtering qualifications are contained within the filter placed on the metric. The metric definition is shown below:

[Count of Customers (Customer Lookup)] {~+} <[Active Female Customers in Central Region]>

Related Topics