Calculated tables in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a calculated table that lists all unique product categories.

Power BI

ProductCategories = DISTINCT([1])

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

ASUM(Products[Category])

BProducts

CFILTER(Products, Products[Category])

DProducts[Category]

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM instead of DISTINCT

Passing the whole table instead of a column

The DISTINCT function returns unique values from the specified column. Here, Products[Category] is the correct column to get unique categories.

2fill in blank

medium

Complete the code to create a calculated table that filters sales for the year 2023.

Power BI

Sales2023 = FILTER(Sales, 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 > or < which filters wrong years

Using >= which includes 2023 and later years

The FILTER function needs a condition. To get sales only for 2023, use Sales[Year] = 2023.

3fill in blank

hard

Fix the error in the calculated table that tries to sum sales by product.

Power BI

SalesByProduct = SUMMARIZE(Sales, Sales[Product], "TotalSales", [1](Sales[Amount]))

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

ASUM

BSUMMARIZE

CFILTER

DDISTINCT

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUMMARIZE inside itself incorrectly

Using FILTER or DISTINCT which don't aggregate

SUMMARIZE groups data, but to calculate total sales, use SUM on the Amount column.

4fill in blank

hard

Fill both blanks to create a calculated table that lists customers with sales greater than 1000.

Power BI

HighValueCustomers = FILTER([1], [2] > 1000)

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

ACustomers

BSales[Amount]

CCustomers[TotalSales]

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Filtering Sales table instead of Customers

Using Sales[Amount] which is per sale, not per customer

We filter the Customers table where their TotalSales column is greater than 1000.

5fill in blank

hard

Fill all three blanks to create a calculated table that summarizes total sales by region and year.

Power BI

SalesSummary = SUMMARIZE([1], [2], [3], "TotalSales", SUM(Sales[Amount]))

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

ASales

BSales[Region]

CSales[Year]

DCustomers

Attempts:

3 left

💡 Hint

Common Mistakes

Using Customers table instead of Sales

Grouping by wrong columns

SUMMARIZE groups the Sales table by Region and Year, then sums Amount as TotalSales.