Relationships (one-to-many, many-to-many) in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a one-to-many relationship between Sales and Customers tables.

Power BI

Relationship = CREATE_RELATIONSHIP(Sales[CustomerID], Customers[[1]])

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

ACustomerID

BOrderID

CProductID

DSalesID

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a column that does not uniquely identify customers.

Using a column from Sales table instead of Customers.

The one-to-many relationship connects Sales[CustomerID] to Customers[CustomerID]. This key uniquely identifies customers.

2fill in blank

medium

Complete the DAX formula to calculate total sales amount using the related table.

Power BI

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

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

APrice

BCustomerID

COrderDate

DDiscount

Attempts:

3 left

💡 Hint

Common Mistakes

Using CustomerID or OrderDate instead of Price.

Using Discount which is not part of the multiplication here.

The total sales amount is quantity multiplied by price per unit.

3fill in blank

hard

Fix the error in the DAX formula to count unique customers in Sales table.

Power BI

Unique Customers = DISTINCTCOUNT(Sales[[1]])

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

AOrderID

BSalesAmount

CProductID

DCustomerID

Attempts:

3 left

💡 Hint

Common Mistakes

Using OrderID or ProductID which count orders or products, not customers.

Using SalesAmount which is numeric and not an ID.

Counting unique customers requires the CustomerID column.

4fill in blank

hard

Fill both blanks to create a many-to-many relationship between Products and Suppliers tables.

Power BI

Relationship = CREATE_RELATIONSHIP(Products[[1]], Suppliers[[2]])

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

AProductID

BSupplierName

CSupplierID

DProductName

Attempts:

3 left

💡 Hint

Common Mistakes

Using names instead of IDs which may not be unique.

Mixing product and supplier columns incorrectly.

Many-to-many relationships connect ProductID in Products to SupplierID in Suppliers.

5fill in blank

hard

Fill all three blanks to filter Sales by related Customers from a specific city.

Power BI

Filtered Sales = CALCULATE(SUM(Sales[Amount]), Customers[[1]] = "[2]", Sales[[3]] > 0)

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

ACity

BNew York

CQuantity

DOrderDate

Attempts:

3 left

💡 Hint

Common Mistakes

Using OrderDate instead of Quantity for sales filtering.

Using wrong city name or column.

This formula sums sales amounts where customers are from a specific city and sales quantity is positive.