Why DAX powers calculations in Power BI - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a simple measure that sums the Sales column.

Power BI

Total Sales = SUM([1])

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

ACustomers[Name]

BSales[Date]

CSales[Amount]

DProducts[Price]

Attempts:

3 left

💡 Hint

Common Mistakes

Using a non-numeric column like Date or Name in SUM causes errors.

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 per order.

Power BI

Average Sales = AVERAGE([1])

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

ASales[Amount]

BOrders[OrderID]

CCustomers[City]

DProducts[Category]

Attempts:

3 left

💡 Hint

Common Mistakes

Trying to average text or ID columns causes errors or wrong results.

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

3fill in blank

hard

Fix the error in the measure to calculate total sales for 2023 only.

Power BI

Total Sales 2023 = CALCULATE(SUM(Sales[Amount]), Sales[Year] [1] 2023)

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

A===

B=

C==

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '==' or '===' causes syntax errors in DAX.

In DAX, the single equals sign '=' is used for comparison inside CALCULATE filters.

4fill in blank

hard

Fill both blanks to create a measure that counts customers from a specific city.

Power BI

Customer Count = CALCULATE(COUNT(Customers[CustomerID]), Customers[City] [1] "[2]")

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

A=

BNew York

CLos Angeles

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>' instead of '=' for city comparison.

The measure counts customers where the City equals 'New York'.

5fill in blank

hard

Fill both blanks to create a measure that calculates total sales for products priced above 100.

Power BI

High Value Sales = CALCULATE(SUM(Sales[Amount]), Products[Price] [1] [2])

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

A>

B100

C&&

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' reverses the filter logic.

This measure sums sales where product price is greater than 100.