KPI visual in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the DAX measure to calculate total sales for the KPI visual.

Power BI

Total Sales = SUM([1])

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

ACustomers[Name]

BProducts[Category]

CSales[Date]

DSales[Amount]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-numeric column like Sales[Date] inside SUM.

Using unrelated tables like Customers or Products.

The SUM function adds all values in the Sales Amount column, which is needed for total sales.

2fill in blank

medium

Complete the DAX measure to calculate sales growth percentage for the KPI visual.

Power BI

Sales Growth % = DIVIDE([Total Sales] - [1], [1])

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

A[Total Sales]

B[Previous Year Sales]

C[Sales Target]

D[Average Sales]

Attempts:

3 left

💡 Hint

Common Mistakes

Using current total sales in both numerator and denominator.

Using unrelated measures like sales target.

Sales growth compares current sales to previous year sales, so subtract and divide by [Previous Year Sales].

3fill in blank

hard

Fix the error in the DAX measure to calculate average sales per customer for the KPI visual.

Power BI

Avg Sales per Customer = DIVIDE([Total Sales], [1])

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

ACOUNTROWS(Customers)

BCOUNT(Sales[CustomerID])

CSUM(Customers[CustomerID])

DCOUNTROWS(Sales)

Attempts:

3 left

💡 Hint

Common Mistakes

Counting sales rows instead of customers.

Using SUM on CustomerID which is not numeric.

To get average sales per customer, divide total sales by the count of unique customers from the Customers table.

4fill in blank

hard

Fill both blanks to create a KPI visual measure showing variance from target sales.

Power BI

Sales Variance = [Total Sales] [1] [Sales Target] [2]

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

A-

B+

C/

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Adding instead of subtracting sales and target.

Multiplying instead of dividing.

Variance is calculated by subtracting target from actual sales, then dividing by target to get percentage.

5fill in blank

hard

Fill all three blanks to create a KPI measure that shows percentage of sales goal achieved.

Power BI

Sales Goal % = DIVIDE([1], [2]) [3] 100

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

A[Total Sales]

B[Sales Target]

C*

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Subtracting instead of multiplying by 100.

Dividing target by sales instead of sales by target.

To get percentage of goal achieved, divide total sales by sales target, then multiply by 100.