Filter

Returns a filtered subset of elements derived from the given list using conditional expressions.

Syntax & Usage

Filter([LIST], selection criteria)
  • Create a list from which you want to derive the subset of elements.
  • Add the Filter block to the list; choose a data point and set the conditional expression.
  • Select "Exclude from Result Set" if you want to remove the filtered elements from the list (as opposed to creating a list from them).

Example

This example returns a list of elements from the Manufacturer hierarchy whose net profit is greater that 90,000:

{Filter({AllMembers([manufacturers].[Manufacturer])},([data].[dateKey year].[2010],[measures].[data net profit])>90000)}