Card and multi-row card in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a Card visual showing total sales.

Power BI

TotalSales = SUM(Sales[[1]])

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

ACustomer

BDate

CAmount

DProduct

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a non-numeric column like Date or Customer.

The SUM function sums the values in the Amount column to calculate total sales.

2fill in blank

medium

Complete the code to create a Multi-row Card visual showing sales by product.

Power BI

SalesByProduct = SUMMARIZE(Sales, Sales[Product], "Total", SUM(Sales[[1]]))

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

AAmount

BCustomer

CRegion

DDate

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-numeric column for summing.

The SUMMARIZE function groups sales by product and sums the Amount column.

3fill in blank

hard

Fix the error in the DAX measure to display total sales in a Card visual.

Power BI

TotalSales = SUM(Sales[[1]])

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

AProductName

BAmount

CSaleDate

DSalesAmount

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect or non-existent column names.

The correct column name is Amount. Using SalesAmount or others causes errors.

4fill in blank

hard

Fill both blanks to create a Multi-row Card showing total sales by region.

Power BI

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

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

ARegion

BAmount

CDate

DCustomer

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up grouping and summing columns.

The SUMMARIZE groups by Region and sums the Amount column for total sales.

5fill in blank

hard

Fill all three blanks to create a measure showing average sales per customer for a Card visual.

Power BI

AvgSalesPerCustomer = DIVIDE(SUM(Sales[[1]]), DISTINCTCOUNT(Sales[[2]]), [3])

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

AAmount

BCustomerID

C0

DDate

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong columns or missing alternate result in DIVIDE.

This measure sums Amount, divides by distinct customers counted by CustomerID, and returns 0 if division by zero occurs.