Report-level filters in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to retrieve the report-level filter on the 'Region' field.

Power BI

FILTERS('Sales'[[1]])

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

ADate

BRegion

CProduct

DCustomer

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a field that is not present in the report-level filter pane.

Using a field that filters only one page instead of the whole report.

The 'Region' field is used to filter the entire report at the report level.

2fill in blank

medium

Complete the DAX expression to check if the report-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'

AQuarter

BMonth

CDay

DYear

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Month' or 'Day' which are more granular than the report-level filter intended.

Confusing 'Quarter' with 'Year'.

Checking 'Year' ensures the report-level filter on the year is active.

3fill in blank

hard

Fix the error in the DAX formula to correctly ignore the report-level filter on 'Category'.

Power BI

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

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

ACategory

BSubcategory

CProductName

DBrand

Attempts:

3 left

💡 Hint

Common Mistakes

Using a more detailed field like 'ProductName' which does not match the report-level filter.

Using a field unrelated to the filter context.

Using ALL on 'Category' removes filters on that field, which is useful to ignore report-level filters on 'Category'.

4fill in blank

hard

Fill both blanks to create a measure that respects report-level filters on 'Region' and 'Year'.

Power BI

CALCULATE(SUM('Sales'[Amount]), [1]('Sales'[Region]), [2]('Date'[Year]))

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

AFILTER

BALL

CVALUES

DREMOVEFILTERS

Attempts:

3 left

💡 Hint

Common Mistakes

Using ALL or REMOVEFILTERS removes filters instead of respecting them.

Using FILTER requires a table expression, which is more complex here.

Using VALUES keeps the current filter context on 'Region' and 'Year' from report-level filters.

5fill in blank

hard

Fill all three blanks to create a measure that ignores report-level filters on 'Category' and 'Year' but respects 'Region'.

Power BI

CALCULATE(SUM('Sales'[Amount]), [1]('Product'[Category]), [2]('Date'[Year]), [3]('Sales'[Region]))

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

AREMOVEFILTERS

BALL

CVALUES

DFILTER

Attempts:

3 left

💡 Hint

Common Mistakes

Using VALUES for all blanks, which keeps all filters.

Using ALL for 'Region' which removes its filter.

ALL removes filters on 'Category' and 'Year', while VALUES keeps the filter on 'Region'.