ALL function for removing filters in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to remove filters from the 'Sales' table using the ALL function.

Power BI

Total Sales All = CALCULATE(SUM(Sales[Amount]), [1](Sales))

Drag options to blanks, or click blank then click option'

AREMOVEFILTERS

BFILTER

CALL

DVALUES

Attempts:

3 left

💡 Hint

Common Mistakes

Using FILTER instead of ALL causes syntax errors.

Using VALUES does not remove filters but returns distinct values.

The ALL function removes all filters from the specified table or column, allowing calculation over the entire dataset.

2fill in blank

medium

Complete the code to calculate total sales ignoring filters on the 'Product' column.

Power BI

Total Sales All Products = CALCULATE(SUM(Sales[Amount]), ALL(Sales[[1]]))

Drag options to blanks, or click blank then click option'

AProduct

BDate

CCustomer

DRegion

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a column unrelated to products.

Using a table name instead of a column name.

The ALL function removes filters from the specified column. Here, removing filters from Sales[Product] calculates total sales for all products.

3fill in blank

hard

Fix the error in the code to correctly remove filters from the 'Region' column.

Power BI

Total Sales All Regions = CALCULATE(SUM(Sales[Amount]), ALL(Sales[1]Region))

Drag options to blanks, or click blank then click option'

A[Region]

B(Region)

C.Region

D{Region}

Attempts:

3 left

💡 Hint

Common Mistakes

Using parentheses instead of square brackets.

Omitting brackets entirely.

In DAX, columns are referenced with square brackets inside the table name, like Sales[Region]. Using parentheses or other symbols causes syntax errors.

4fill in blank

hard

Fill both blanks to calculate total sales ignoring filters on both 'Product' and 'Region' columns.

Power BI

Total Sales All Prod & Region = CALCULATE(SUM(Sales[Amount]), ALL(Sales[[1]]), ALL(Sales[[2]]))

Drag options to blanks, or click blank then click option'

AProduct

BDate

CRegion

DCustomer

Attempts:

3 left

💡 Hint

Common Mistakes

Using unrelated columns like Date or Customer.

Swapping the order of columns incorrectly.

Using ALL(Sales[Product]) and ALL(Sales[Region]) removes filters from both columns, calculating total sales across all products and regions.

5fill in blank

hard

Fill all three blanks to calculate total sales ignoring filters on 'Product', 'Region', and 'Date' columns.

Power BI

Total Sales All Prod, Region & Date = CALCULATE(SUM(Sales[Amount]), ALL(Sales[[1]]), ALL(Sales[[2]]), ALL(Sales[[3]]))

Drag options to blanks, or click blank then click option'

ACustomer

BDate

CRegion

DProduct

Attempts:

3 left

💡 Hint

Common Mistakes

Including 'Customer' instead of 'Date'.

Mixing up the order of columns.

Removing filters from Product, Region, and Date columns calculates total sales across all these dimensions.