Reducing model size in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to remove unnecessary columns from the table.

Power BI

Table.RemoveColumns(Source, [1])

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

AColumnsToRemove

BRowsToRemove

CRowsToKeep

DColumnsToKeep

Attempts:

3 left

💡 Hint

Common Mistakes

Using columns to keep instead of columns to remove

Confusing rows with columns

The Table.RemoveColumns function requires a list of columns to remove, so you must provide the ColumnsToRemove list.

2fill in blank

medium

Complete the DAX formula to calculate the size of the model in MB.

Power BI

ModelSizeMB = DIVIDE(SUMX(ALL('Table'), 'Table'[SizeInBytes]), [1])

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

A512

B1048576

C1000

D1024

Attempts:

3 left

💡 Hint

Common Mistakes

Using 1024 instead of 1,048,576

Using 1000 which is for decimal units, not binary

To convert bytes to megabytes, divide by 1024 * 1024 = 1,048,576.

3fill in blank

hard

Fix the error in the DAX formula to calculate distinct count of customers after filtering.

Power BI

FilteredCustomers = CALCULATE(DISTINCTCOUNT('Sales'[CustomerID]), [1])

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

A'Sales'[Amount] > 100

BVALUES('Sales'[CustomerID])

CALL('Sales')

DFILTER('Sales', 'Sales'[Amount] > 100)

Attempts:

3 left

💡 Hint

Common Mistakes

Using only a condition without FILTER

Using ALL which removes filters instead of applying them

The CALCULATE function expects a filter expression like FILTER(table, condition) to apply row context properly.

4fill in blank

hard

Fill both blanks to create a calculated table that keeps only top 10 products by sales.

Power BI

TopProducts = TOPN([1], 'ProductSales', 'ProductSales'[SalesAmount], [2])

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

A10

B5

CDESC

DASC

Attempts:

3 left

💡 Hint

Common Mistakes

Using ascending order which returns lowest values

Using wrong number of rows

TOPN requires the number of rows to return and the order direction. To get top 10, use 10 and descending order.

5fill in blank

hard

Fill all three blanks to create a measure that calculates average sales only for products with sales above 1000.

Power BI

AvgHighSales = CALCULATE(AVERAGE('Sales'[Amount]), FILTER('Sales', 'Sales'[Amount] [1] [2]), [3])

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

A>

B1000

CALL('Sales')

DSUM('Sales'[Amount])

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM instead of ALL in the third blank

Using wrong comparison operator

The FILTER condition needs a comparison operator and a value. The third blank uses ALL to remove other filters except the FILTER condition.