The filter functions return a specific data type, find values in related tables, and filter by related values. The Lookup function works by using the tables and relationships between them. Filter functions help you to manipulate data context for creating dynamic calculations.
Following is the list of filter functions supported in Wyn Enterprise:
Description
The ALL function returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. This function is useful for clearing filters and creating calculations on all the rows in a table.
Syntax
ALL([<table>|<column>[,<column>[,<column>[,…]]]])
Parameters
Return Value
The table or column with filters removed.
Example
ALL('Sales')
The CALCULATE function evaluates an expression in a modified filter context.
CALCULATE(<expression>[,<filter1> [,<filter2> [, …]]])
The value is the result of the expression.
CALCULATE ( SUMX ('Sales', Sales[Sales Amount] ), 'Sales'[OrderKey] > 20 && 'Sales'[OrderKey] <1010, Filter('Sales','Sales'[OrderDateKey] > 1 && 'Sales'[OrderDateKey] <100), REMOVEFILTERS('Sale'[CustomerName]) )
The CALCULATETABLE function evaluates a table expression in a modified filter context.
The table of values.
The FILTER function returns a table that represents a subset of another table or expression.
FILTER(<table>,<filter>)
A table containing only the filtered rows.
Filter('Sales','Sales'[OrderDateKey] > 1 && 'Sales'[OrderDateKey] <100)
The REMOVEFILTERS function clears filters from the specified tables or columns.
REMOVEFILTERS(<column>)
N/A.
CALCULATE ( SUMX ('Sales', Sales[Sales Amount] ), REMOVEFILTERS('Sale'[CustomerName]) )