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)}