DAX Function

FILTER Power BI DAX exercises.

These concepts all use FILTER. Work through related PBIX exercises, compare the patterns, and submit numeric answers to save your progress.

View all DAX functions

7Related concepts

Concepts Using FILTER

IntermediateFILTER CALCULATE COUNTROWS

Advanced Filtering with DAX: Using FILTER for Context Modification

Understand and apply the DAX FILTER function to create virtual tables and modify filter context dynamically within measures, enabling complex aggregations based on related table conditions.

Open

IntermediateFILTER EARLIER VAR

Calculating Cumulative Totals Over Dates Using FILTER and EARLIER

Understand and apply the FILTER and EARLIER functions to create a cumulative total over a date column in Power BI, and explore an alternative approach using variables.

Open

IntermediateCALCULATE VALUES FILTER

Conditional Data Omission in Matrix Visuals using CALCULATE, VALUES, and FILTER

Learn to create DAX measures that conditionally omit specific data categories (like environments) from calculations in a matrix visual, leveraging the CALCULATE, VALUES, and FILTER functions to manipulate filter context.

Open

BeginnerEVALUATE FILTER ORDER BY

DAX Query: Identifying Brexit 'Remain' Stronghold Areas by Vote Ratio

Learn to write a DAX query using EVALUATE to filter and order data based on a calculated ratio between 'Remain' and 'Leave' votes.

Open

BeginnerSUMX FILTER YEAR AND (or && operator)

Filtering Data with Multiple Criteria using DAX

Learn how to use the FILTER function with multiple criteria (AND operator) to selectively sum data in Power BI, building on basic SUMX measures.

Open

IntermediateFILTER SUMX COUNTROWS CONTAINSSTRING RELATED

Filtering Tables with the DAX FILTER Function for Dynamic Calculations

Understand and apply the DAX FILTER function to create filtered tables for other functions, enabling dynamic calculations based on specific conditions.

Open

BeginnerFILTER AVERAGEX

Implementing the FILTER Function for Conditional Aggregations in DAX

Learn how to effectively use the `FILTER` function within an iterator like `AVERAGEX` to perform calculations on a dynamically filtered subset of a table.

Open