Table and matrix layouts in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a simple table visual showing Sales Amount.

Power BI

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

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

ASUM(Sales[SalesAmount])

BCOUNT(Sales[SalesAmount])

CAVERAGE(Sales[SalesAmount])

DMIN(Sales[SalesAmount])

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNT instead of SUM

Using AVERAGE which calculates mean, not total

Use SUM to calculate the total sales amount for each product in the table.

2fill in blank

medium

Complete the code to add a matrix visual grouping by Region and Product.

Power BI

Matrix = SUMMARIZE(Sales, Sales[Region], Sales[Product], "TotalSales", [1])

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

ACOUNT(Sales[SalesAmount])

BSUM(Sales[SalesAmount])

CMAX(Sales[SalesAmount])

DMIN(Sales[SalesAmount])

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNT which counts rows, not sums values

Using MAX or MIN which find extremes, not totals

SUM aggregates sales amount by Region and Product for the matrix layout.

3fill in blank

hard

Fix the error in the measure to calculate total sales for the matrix.

Power BI

Total Sales = CALCULATE([1], ALL(Sales[Product]))

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

AAVERAGE(Sales[SalesAmount])

BCOUNT(Sales[SalesAmount])

CSUMX(Sales, Sales[SalesAmount])

DSUM(Sales[SalesAmount])

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNT which counts rows

Using AVERAGE which calculates mean

Using SUMX unnecessarily

CALCULATE needs a proper aggregation like SUM to compute total sales ignoring product filter.

4fill in blank

hard

Fill both blanks to create a matrix showing sales by Year and Category with total sales.

Power BI

Matrix = SUMMARIZE(Sales, Sales[[1]], Sales[[2]], "TotalSales", SUM(Sales[SalesAmount]))

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

AYear

BCategory

CRegion

DProduct

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping Category and Year

Using Region or Product instead of Category

Year and Category are common matrix row and column groups for sales analysis.

5fill in blank

hard

Fill all three blanks to create a measure that calculates average sales per product in a matrix.

Power BI

Avg Sales = DIVIDE(SUM(Sales[[1]]), COUNT(Sales[[2]]), [3])

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

ASalesAmount

BProductID

C0

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using ProductID in SUM

Using 1 instead of 0 as alternate result

Swapping SUM and COUNT columns

Sum sales amount divided by count of products, with 0 as alternate result if division by zero.