Why data modeling connects related tables in Power BI - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a relationship between two tables in Power BI.

Power BI

Model.createRelationship(table1[[1]], table2[ID])

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

ACustomerID

BProductName

CSalesAmount

DDate

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a column that does not exist in both tables.

Using a measure or value column instead of a key column.

The relationship is usually created on a key column like CustomerID that exists in both tables.

2fill in blank

medium

Complete the code to filter related rows using DAX.

Power BI

CALCULATE(SUM(Sales[Amount]), RELATEDTABLE([1]))

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

ACustomers

BProducts

CDates

DRegions

Attempts:

3 left

💡 Hint

Common Mistakes

Using a table unrelated to sales.

Confusing RELATEDTABLE with RELATED function.

The RELATEDTABLE function filters rows in the related Products table.

3fill in blank

hard

Fix the error in the DAX expression to correctly relate tables.

Power BI

SUMX(RELATEDTABLE([1]), [SalesAmount])

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

ASales

BCustomers

CProducts

DOrders

Attempts:

3 left

💡 Hint

Common Mistakes

Using the sales table inside RELATED causes an error.

Choosing unrelated tables that do not connect to the current table.

The RELATEDTABLE function returns a table related to the current row, so Products is the correct table to reference for sales amount aggregation.

4fill in blank

hard

Fill both blanks to create a relationship and use it in a measure.

Power BI

Relationship = CREATE_RELATIONSHIP([1][OrderID], [2][ID])

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

AOrders

BCustomers

CSales

DProducts

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up which table has OrderID and which has ID.

Using unrelated tables like Customers or Products here.

The Orders table's OrderID connects to the Sales table's ID to relate sales to orders.

5fill in blank

hard

Fill all three blanks to write a DAX measure that sums sales filtered by related customer region.

Power BI

TotalSalesRegion = CALCULATE(SUM([1][Amount]), RELATED([2][[3]]))

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

ASales

BCustomers

CRegion

DOrders

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong table for sales amount.

Referencing a column that does not exist in the related table.

The measure sums Sales[Amount] filtered by the related Customers table's Region column.