Composite models in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to enable DirectQuery mode in a composite model.

Power BI

Model.EnableCompositeMode([1])

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

Aenable

Bfalse

Ctrue

Ddisable

Attempts:

3 left

💡 Hint

Common Mistakes

Using string values instead of boolean

Confusing enable/disable keywords

Setting true enables DirectQuery mode in the composite model.

2fill in blank

medium

Complete the DAX expression to create a calculated table combining DirectQuery and Import data.

Power BI

CombinedTable = UNION(ImportTable, [1])

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

ADirectQueryTable

BSUMMARIZE(ImportTable)

CFILTER(DirectQueryTable, TRUE())

DVALUES(ImportTable)

Attempts:

3 left

💡 Hint

Common Mistakes

Using aggregation functions instead of table names

Filtering unnecessarily

The UNION function combines rows from ImportTable and DirectQueryTable.

3fill in blank

hard

Fix the error in the DAX measure to calculate sales from both Import and DirectQuery tables.

Power BI

TotalSales = SUM(ImportSales[Amount]) + [1]

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

ASUM(ImportSales[Amount])

BCALCULATE(SUM(DirectSales[Amount]))

CSUMX(DirectSales, Amount)

DSUM(DirectSales[Amount])

Attempts:

3 left

💡 Hint

Common Mistakes

Using CALCULATE unnecessarily

Summing the wrong table

Duplicating ImportSales sum

Use SUM(DirectSales[Amount]) to add sales from the DirectQuery table correctly.

4fill in blank

hard

Fill both blanks to create a relationship between Import and DirectQuery tables.

Power BI

CREATE RELATIONSHIP [1] ON [2]

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

AImportTable[CustomerID] = DirectQueryTable[CustomerID]

BImportTable[Date] = DirectQueryTable[Date]

CDirectQueryTable[CustomerID]

DImportTable[CustomerID]

Attempts:

3 left

💡 Hint

Common Mistakes

Using only one side of the relationship

Mixing columns from different tables incorrectly

The relationship is created by matching CustomerID columns from both tables.

5fill in blank

hard

Fill all three blanks to write a DAX measure that filters Import data by DirectQuery date range.

Power BI

FilteredSales = CALCULATE(SUM(ImportSales[Amount]), ImportSales[Date] [1] DirectQueryDates[StartDate], ImportSales[Date] [2] DirectQueryDates[EndDate], [3])

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

A>=

B<=

CALL(ImportSales)

DFILTER(ImportSales, TRUE())

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong comparison operators

Not clearing filters properly

Using FILTER unnecessarily

The measure filters ImportSales dates between DirectQueryDates start and end dates, removing other filters with ALL.