Page-level filters in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to apply a page-level filter for the 'Region' column.

Power BI

FILTERS('Sales'[[1]])

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

ACustomer

BDate

CProduct

DRegion

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a column that is not present in the data model.

Using a measure instead of a column for filtering.

The 'Region' column is used to filter data at the page level in Power BI.

2fill in blank

medium

Complete the DAX expression to check if the page-level filter on 'Year' is active.

Power BI

IF(HASONEVALUE('Date'[[1]]), "Filtered", "Not Filtered")

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

AYear

BMonth

CDay

DQuarter

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Month' or 'Day' instead of 'Year' for the filter check.

Not using HASONEVALUE function correctly.

HASONEVALUE checks if the 'Year' column has a single filter applied at the page level.

3fill in blank

hard

Fix the error in the DAX formula to correctly apply a page-level filter on 'Category'.

Power BI

CALCULATE(SUM('Sales'[Amount]), FILTERS('Product'[[1]]))

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

ADate

BAmount

CCategory

DRegion

Attempts:

3 left

💡 Hint

Common Mistakes

Using a measure or unrelated column inside FILTERS.

Referencing the wrong table for the filter column.

The FILTERS function should reference the 'Category' column from the 'Product' table to apply the page-level filter correctly.

4fill in blank

hard

Fill both blanks to create a measure that returns the selected page-level filter value for 'Country'.

Power BI

SelectedCountry = IF(HASONEVALUE('Location'[[1]]), VALUES('Location'[[2]]), "Multiple")

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

ACountry

BRegion

DCity

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing different columns like 'Region' and 'Country' in the same formula.

Using a column that is not filtered at the page level.

Both blanks should be filled with 'Country' to check and return the selected country filter at the page level.

5fill in blank

hard

Fill both blanks to create a measure that sums sales filtered by the page-level filter on 'Segment' and 'Year'.

Power BI

FilteredSales = CALCULATE(SUM('Sales'[Amount]), FILTERS('Customer'[[1]]), FILTERS('Date'[[2]]), )

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

ASegment

BYear

C,

DAND

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'AND' instead of a comma to separate filters.

Referencing wrong columns for the filters.

The measure uses FILTERS on 'Segment' and 'Year' columns and separates the filters with a comma inside CALCULATE to apply both filters at the page level.