Relationship direction and cross-filtering in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to set the relationship direction to single in Power BI.

Power BI

Relationship.Direction = [1]

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

ADouble

BBoth

CNone

DSingle

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Both' when only one direction is needed.

Using 'Double' which is not a valid option.

In Power BI, the relationship direction can be set to 'Single' or 'Both'. 'Single' means filtering flows in one direction only.

2fill in blank

medium

Complete the DAX expression to calculate total sales filtered by related product category.

Power BI

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

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

ADate

BProduct

CCategory

DCustomer

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Product' instead of 'Category' which does not filter by category.

Choosing unrelated tables like 'Customer' or 'Date'.

The RELATEDTABLE function filters the Sales table by the related Category table, so 'Category' is the correct table to use.

3fill in blank

hard

Fix the error in the DAX formula to enable cross-filtering from 'Customers' to 'Sales'.

Power BI

CrossFilter = CROSSFILTER(Customers[CustomerID], Sales[CustomerID], [1])

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

ANone

BBoth

CSingle

DDouble

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Single' which only filters one way.

Choosing 'Double' which is not a valid option.

The CROSSFILTER function requires 'Both' to enable cross-filtering in both directions between Customers and Sales tables.

4fill in blank

hard

Fill both blanks to create a bidirectional relationship between 'Orders' and 'Products' tables.

Power BI

CREATE RELATIONSHIP Orders[ProductID] TO Products[ProductID] WITH CROSSFILTER [1] AND DIRECTION [2]

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

ABoth

BSingle

DNone

Attempts:

3 left

💡 Hint

Common Mistakes

Setting cross-filter or direction to 'Single' which limits filtering to one way.

Using 'None' which disables filtering.

To create a bidirectional relationship, both cross-filter and direction must be set to 'Both'.

5fill in blank

hard

Fill all three blanks to write a DAX measure that sums sales filtered by related product category with bidirectional filtering.

Power BI

TotalCategorySales = CALCULATE(SUM(Sales[Amount]), CROSSFILTER(Sales[ProductID], [1][ProductID], [2]), RELATEDTABLE([3]))

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

AProducts

BBoth

CCategory

DSingle

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Single' instead of 'Both' for cross-filter direction.

Choosing wrong tables for RELATEDTABLE or CROSSFILTER.

The CROSSFILTER function uses 'Products' table and 'Both' direction for bidirectional filtering. RELATEDTABLE uses 'Category' to filter sales by product category.