Filter rows

Use the Filter Rows transformation to keep only rows that meet specified conditions.

Filtering rows reduces the amount of data in a query and ensures that only relevant records are available for analysis and reporting.

Filter rows#

The following example filters a query to keep only rows where Country is United States of America and Sum of COGS is greater than 500250.

1. On the Transform tab, select Filter Rows.
   

   

   The Filter Rows dialog opens.

2. Enter the following example filters. For a full list of filter options, see Filter dialog options later in the article.

   1. In Column Name, select Country.
   2. In Operator, select Is.
   3. In Value, select United States of America.
   4. Select Add Filter.
   5. Select And.
   6. In Column Name, select Sum of COGS.
   7. In Operator, select Is greater than.
   8. In Value, enter 500250.
      

   

3. Select Apply.

After you apply the filter, only rows that satisfy the specified conditions remain in the query results.

The applied filter appears in Performed Steps and applies to subsequent transformations, calculations, and reporting scenarios.

Options for filter dialog#

The filter dialog supports the following options:

• Condition: Defines how to combine multiple filter conditions.
  • Use And when all conditions must be true.
  • Use Or when any condition is true.
• Column Name: Select the measure or dimension to filter on.
• Operator: Select the condition to apply.
  • For text columns, operators include Is, Is not, In, and Not in.
  • For numeric columns, operators include Is, Is not, Less than, Greater than, Less than or equal to, and Greater than or equal to.
• Value: Enter a value or select one from the list.
• Add Filter: Add more filter conditions.