First Power BI report - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a new measure that sums the Sales column.

Power BI

Total Sales = SUM([1])

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

ASales[Quantity]

BSales[Amount]

CProducts[Price]

DCustomers[ID]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a column from the wrong table.

Using a non-numeric column.

The SUM function needs the Sales Amount column to calculate total sales.

2fill in blank

medium

Complete the code to filter sales for the year 2023.

Power BI

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

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

A2022

B2024

C2023

D2021

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong year value.

Using a string instead of a number.

We want to filter sales for the year 2023, so the filter value must be 2023.

3fill in blank

hard

Fix the error in the measure to calculate average sales.

Power BI

Average Sales = AVERAGE([1])

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

ASales[Amount]

BProducts[Category]

CCustomers[Age]

DSales[Quantity]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-numeric or unrelated column.

Using quantity instead of amount.

The AVERAGE function must use the Sales Amount column to calculate average sales.

4fill in blank

hard

Fill both blanks to create a measure that counts customers from USA.

Power BI

USA Customers = CALCULATE(COUNT([1]), Customers[Country] = [2])

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

ACustomers[CustomerID]

BSales[Amount]

C"USA"

D"Canada"

Attempts:

3 left

💡 Hint

Common Mistakes

Counting sales amount instead of customers.

Using wrong country name or missing quotes.

We count CustomerID to count customers, and filter where Country equals "USA".

5fill in blank

hard

Fill all three blanks to create a measure that sums sales for 2023 and filters only products in category 'Electronics'.

Power BI

Electronics Sales 2023 = CALCULATE(SUM([1]), Sales[Year] = [2], Products[Category] = [3])

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

ASales[Amount]

B2023

C"Electronics"

DSales[Quantity]

Attempts:

3 left

💡 Hint

Common Mistakes

Using quantity instead of amount.

Forgetting quotes around category name.

Using wrong year value.

The measure sums Sales Amount, filters year 2023, and filters category "Electronics".