Article

DAX Language - FILTER Function


A-Badde | Posted on April 04, 20

FILTER Function

 Description:

The Filter function is used to return a subset table of an expression or a table.

 Return Value:

Filter returns a table containing only the filtered rows.

 Syntax:

FILTER( <Table> , <FilterExpression> )
  • Description of the parameters:

PARAMETER

DESCRIPTION

Table

Table or expression table to be filtered.

FilterExpression

A boolean expression that is to be evaluated for each row of the table.


 Example:

  In our data model, we have a Product table which contains the unit price of each product, we want to add a new Product table where the unit price of products is greater than $1000.

  To add the new table, we will use the formula below:

New_Product = FILTER('Product', 'Product'[UnitPrice] > 1000)

 

Note that FILTER function is generally used as a function that is embedded in other functions that require a table as an argument.

 

Related Video:

 

 


(0) Comments

There is no comment

Leave a Comment

Your email address will not be published. Required fields are marked *

Add to favorite
Categories
Recent Posts
DAX Language - CONTAINS Function
A-Badde | May 09, 20

The CONTAINS function returns a boolean value, TRUE if each ...Read More


DAX Language - RANKX Function
A-Badde | May 05, 20

The RANKX function returns a single integer value that repre...Read More


DAX Language - AND and OR Functions
A-Badde | April 10, 20

AND/OR functions check whether all arguments are TRUE or one...Read More


DAX Language - Variables in DAX
A-Badde | April 10, 20

Use Var keyword to store the result of an expression as a na...Read More