DAX - FILTER function


Advertisements

Description

Returns a table that represents a subset of another table or expression.

Syntax

FILTER (<table>, <filter>) 

Parameters

Sr.No. Parameter & Description
1

table

The table to be filtered. The table can also be an expression that results in a table.

2

filter

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

Return Value

A table containing only the filtered rows.

Remarks

You can use DAX FILTER function to reduce the number of rows in the table that you are working with, and use only specific data in calculations.

DAX FILTER function is not used independently, but as a function that is embedded in other functions that require a table as an argument.

Example

Medal Count Summer Sports:= COUNTAX ( 
   FILTER (Results, Results[Season] = "Summer"), Results[Medal]
) 
dax_functions_filter.htm

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements