Map visualizations in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add a map visualization showing sales by country.

Power BI

Map = SUMMARIZE(Sales, Sales[Country], "TotalSales", [1](Sales[Amount]))

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

AAVERAGE

BCOUNT

CSUM

DMIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNT instead of SUM

Using AVERAGE which gives average, not total

We use SUM to add up sales amounts by country for the map.

2fill in blank

medium

Complete the code to filter map data to only show sales from 2023.

Power BI

FilteredMap = FILTER(Sales, Sales[Year] = [1])

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

A2023

B2021

C2024

D2022

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a wrong year

Using a string instead of a number

We filter for the year 2023 to show only that year's sales on the map.

3fill in blank

hard

Fix the error in the DAX measure to calculate total sales for the map.

Power BI

TotalSales = CALCULATE([1](Sales[Amount]), ALL(Sales[Region]))

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

ASUM

BAVERAGE

CMIN

DCOUNT

Attempts:

3 left

💡 Hint

Common Mistakes

Using COUNT which counts rows

Using AVERAGE which averages values

The SUM function correctly totals the sales amount ignoring region filters.

4fill in blank

hard

Fill both blanks to create a measure that calculates sales growth percentage for the map.

Power BI

SalesGrowth = DIVIDE(SUM(Sales[Amount]) - SUM(Sales[Amount])[1] 1, SUM(Sales[Amount])[2] 1)

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

A-

B+

C/

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus instead of minus

Using multiplication or division incorrectly

We subtract last year's sales ({{BLANK_1}}) and divide by last year's sales ({{BLANK_2}}) to get growth.

5fill in blank

hard

Fill all three blanks to create a map measure that shows average sales per city filtered by region.

Power BI

AvgSalesCity = CALCULATE([1](Sales[Amount]), FILTER(Sales, Sales[Region] [2] [3]))

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

AAVERAGE

B=

C"West"

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM instead of AVERAGE

Using wrong comparison operators

Missing quotes around region name

We calculate the AVERAGE sales amount, filtering where region equals "West".