Why interactivity enables exploration in Power BI - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a slicer that filters data by year.

Power BI

Slicer = SELECTCOLUMNS(FILTER(Sales, Sales[Year] [1] 2020), "Year", Sales[Year])

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

A>=

B=

C<

D!=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '=' limits the slicer to only the year 2020.

Using '<' or '!=' will exclude the desired years.

Using '>=' allows the slicer to include all years from 2020 onwards, enabling exploration of recent data.

2fill in blank

medium

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

Power BI

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

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

A>

BCONTAINS

C=

DIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'IN' or 'CONTAINS' is incorrect because SELECTEDVALUE returns a single value.

Using '>' does not filter categories properly.

The '=' operator compares the sales category to the selected product category, filtering the sales correctly.

3fill in blank

hard

Fix the error in the DAX formula to calculate average sales per customer.

Power BI

Avg Sales per Customer = DIVIDE(SUM(Sales[Amount]), DISTINCTCOUNT(Sales[1]CustomerID))

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

A[CustomerID]

B(CustomerID)

C{CustomerID}

D<CustomerID>

Attempts:

3 left

💡 Hint

Common Mistakes

Using parentheses or curly braces instead of square brackets.

Leaving out brackets causes syntax errors.

In DAX, column references must be enclosed in square brackets []. Using [CustomerID] is correct syntax.

4fill in blank

hard

Fill both blanks to create a measure that counts sales greater than 1000 and filters by region.

Power BI

High Sales Count = CALCULATE(COUNTROWS(Sales), Sales[Amount] [1] 1000, Sales[Region] [2] "West")

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

A>

B=

C==

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' for amount filter.

Using '==' which is not valid in DAX.

Using wrong operator for region filter.

The '>' operator filters sales amounts greater than 1000, and '=' filters the region exactly as 'West'.

5fill in blank

hard

Complete the code to create a measure that calculates sales growth percentage compared to previous year.

Power BI

Sales Growth % = DIVIDE(SUM(Sales[Amount]) - CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Sales[Date]))), CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Sales[Date],)) * 100 [1] "No Growth"

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

A)

B,

CIFERROR

DELSE

Attempts:

3 left

💡 Hint

Common Mistakes

Missing closing parentheses causes syntax errors.

Using ELSE instead of IFERROR for error handling.

Omitting commas between function arguments.

Closing parentheses and commas are needed to complete function calls. IFERROR handles division errors by returning 'No Growth'.