Aggregations for performance in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to calculate the total sales amount.

Power BI

Total Sales = SUM([1])

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

ASales[Amount]

BSales[Date]

CCustomers[Name]

DProducts[Category]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-numeric column like dates or names in SUM.

Forgetting to specify the table and column.

The SUM function adds all values in the Sales[Amount] column to calculate total sales.

2fill in blank

medium

Complete the code to calculate the average sales amount.

Power BI

Average Sales = AVERAGE([1])

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

ASales[Quantity]

BSales[Amount]

CProducts[Price]

DCustomers[Age]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-sales column like age or quantity.

Confusing average with sum.

The AVERAGE function calculates the mean of the Sales[Amount] values.

3fill in blank

hard

Fix the error in the code to calculate the maximum sales amount.

Power BI

Max Sales = MAX([1])

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

ASales[Date]

BCustomers[ID]

CSales[Amount]

DProducts[Name]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a date or text column inside MAX.

Not specifying the correct table and column.

The MAX function finds the highest value in the Sales[Amount] column. Using dates or names causes errors.

4fill in blank

hard

Fill the blank to calculate total sales for a specific product category.

Power BI

Category Sales = CALCULATE(SUM(Sales[Amount]), Sales[Category] [1] "Electronics")

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

A=

B==

CIN

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '==' instead of '=' in DAX.

Using '>' which is not correct for category filtering.

Use = to filter sales where the category is 'Electronics'. The correct syntax is Sales[Category] = "Electronics" or using IN for multiple values.

5fill in blank

hard

Fill all three blanks to create a measure that counts customers with sales above 1000.

Power BI

High Value Customers = CALCULATE(DISTINCTCOUNT([1]), FILTER(ALL(Sales), Sales[Amount] [2] [3]))

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

ACustomers[CustomerID]

B>

C1000

DSales[Date]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a date column instead of customer ID for counting.

Using '=' instead of '>' for filtering sales above 1000.

This measure counts unique customers whose sales amount is greater than 1000. Use Customers[CustomerID] for counting, > for comparison, and 1000 as the threshold.