SUMX and iterators in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to calculate the total sales amount using SUMX.

Power BI

Total Sales = SUMX(Sales, Sales[Quantity] [1] Sales[Price])

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

A*

B-

C+

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using + instead of * causes incorrect total calculation.

Using / or - will produce wrong results.

The SUMX function iterates over the Sales table and multiplies Quantity by Price for each row, then sums the results.

2fill in blank

medium

Complete the code to calculate total profit by iterating over the Sales table.

Power BI

Total Profit = SUMX(Sales, Sales[Quantity] * (Sales[Price] [1] Sales[Cost]))

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

A+

B/

C-

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using + instead of - will add cost to price, which is incorrect.

Using * or / inside parentheses changes the formula meaning.

Profit per row is Price minus Cost, multiplied by Quantity. SUMX sums these profits.

3fill in blank

hard

Fix the error in the code to correctly calculate total discount amount.

Power BI

Total Discount = SUMX(Sales, Sales[Quantity] [1] Sales[Discount])

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

A+

B/

C-

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using + adds values incorrectly.

Using - or / changes the meaning and causes errors.

To get total discount, multiply Quantity by Discount per unit, then sum with SUMX.

4fill in blank

hard

Fill both blanks to calculate total revenue after discount.

Power BI

Total Revenue = SUMX(Sales, Sales[Quantity] [1] (Sales[Price] [2] Sales[Discount]))

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

A*

B-

C+

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using + instead of - inside parentheses adds discount incorrectly.

Using + or / instead of * for quantity multiplication causes errors.

Revenue per row is Quantity times (Price minus Discount). SUMX sums these values.

5fill in blank

hard

Fill all three blanks to calculate total tax amount on sales.

Power BI

Total Tax = SUMX(Sales, Sales[Quantity] [1] Sales[Price] [2] Sales[TaxRate] [3] 0.01)

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

A*

B+

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using + instead of * breaks the multiplication chain.

Using - instead of * causes wrong calculations.

Tax per row is Quantity times Price times TaxRate times 0.01 (to convert percent). SUMX sums these taxes.