FILTER Picks Rows

Part of the DAX with CALCULATE section of Coddy's Power BI journey. Lesson 14 of 24.

FILTER(Table, test) returns the rows that pass the test.

Big Lines = COUNTROWS(FILTER(Sales, Sales[Quantity] >= 3))

It walks only the rows of the bar.

In CALCULATE, its rows become the rows the measure runs on.

CALCULATE([Revenue], FILTER(Sales, Sales[Amount] >= 10))

Challenge

Write Big Lines: how many order lines have 3 items or more. It is checked for each store.

Start this challenge with Coddy's AI tutor

All lessons in DAX with CALCULATE