Filter context concept in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the DAX formula to calculate total sales filtered by product category.

Power BI

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

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

A"Bikes"

BFILTER

CSUM(Sales[Amount])

DBikes

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to put quotes around text values.

Using a function name instead of a value.

In DAX, text values must be enclosed in double quotes. So to filter by category 'Bikes', use "Bikes".

2fill in blank

medium

Complete the DAX formula to calculate sales only for the year 2023.

Power BI

Sales 2023 = CALCULATE(SUM(Sales[Amount]), Sales[Year] [1] 2023)

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

A=

B==

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using double '==' instead of '=' for comparison.

Using greater or less than operators by mistake.

In DAX, the equality operator is '=', not double equals '=='.

3fill in blank

hard

Fix the error in this DAX formula to correctly filter sales for the 'East' region.

Power BI

East Sales = CALCULATE(SUM(Sales[Amount]), Sales[Region] [1] "East")

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

A==

B===

C=

D=>

Attempts:

3 left

💡 Hint

Common Mistakes

Using double equals '==' or other invalid operators.

Using invalid operators like '===' or '=>.'

DAX uses '=' for equality comparison, not double equals '==' or other operators.

4fill in blank

hard

Fill both blanks to create a measure that calculates total sales for products priced above 100.

Power BI

High Price Sales = CALCULATE(SUM(Sales[Amount]), Sales[Price] [1] [2])

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

A>

B100

C==

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '==' instead of '>' for comparison.

Using '<' which filters prices less than 100.

The filter condition should check if Price is greater than 100, so use '>' and '100'.

5fill in blank

hard

Fill all three blanks to create a measure that calculates total sales for the 'West' region in 2022.

Power BI

West 2022 Sales = CALCULATE(SUM(Sales[Amount]), Sales[Region] [1] [2], Sales[Year] [3] 2022)

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

A=

B"West"

D"East"

Attempts:

3 left

💡 Hint

Common Mistakes

Using invalid operators like '==' instead of '='.

Not quoting text values like "West".

Mixing up regions or years.

Use '=' for equality checks and put text values in quotes. So Region = "West" and Year = 2022.