Handling null and blank values in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to check if a column value is blank in DAX.

Power BI

IsBlankValue = IF(ISBLANK([1]), "Blank", "Not Blank")

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

A0

BBLANK()

CNULL

DTable[Column]

Attempts:

3 left

💡 Hint

Common Mistakes

Using BLANK() inside ISBLANK instead of a column reference.

Using NULL which is not recognized in DAX.

Using 0 which is a number, not a blank check.

In DAX, to check if a column value is blank, you use ISBLANK with the column reference like Table[Column].

2fill in blank

medium

Complete the DAX formula to replace blank values with zero.

Power BI

ReplaceBlank = IF(ISBLANK([1]), 0, [1])

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

A0

BTable[Sales]

CBLANK()

DSUM(Table[Sales])

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 inside ISBLANK which is not a column.

Using BLANK() inside ISBLANK which always returns true.

Using an aggregate like SUM inside ISBLANK incorrectly.

You check if the column Table[Sales] is blank, then replace it with 0; otherwise, keep the original value.

3fill in blank

hard

Fix the error in this DAX measure that counts non-blank values.

Power BI

CountNonBlank = COUNTROWS(FILTER(Table, NOT(ISBLANK([1]))))

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

ATable[Date]

BBLANK()

CTable

DCOUNT(Table[Date])

Attempts:

3 left

💡 Hint

Common Mistakes

Passing the whole Table instead of a column.

Using BLANK() inside ISBLANK which is always blank.

Using COUNT inside FILTER which is invalid.

The FILTER function needs a column reference inside ISBLANK to check each row's value. Table[Date] is correct.

4fill in blank

hard

Fill both blanks to create a measure that returns 'No Data' if the sum is blank, else the sum.

Power BI

TotalSales = IF(ISBLANK([1]), [2], SUM(Sales[Amount]))

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

ASUM(Sales[Amount])

B"No Data"

C0

DSales[Amount]

Attempts:

3 left

💡 Hint

Common Mistakes

Using Sales[Amount] directly inside ISBLANK instead of the sum.

Using 0 instead of the text "No Data".

Swapping the blanks' values.

The measure checks if the sum of Sales[Amount] is blank. If yes, it returns the text "No Data"; otherwise, it returns the sum.

5fill in blank

hard

Fill all three blanks to create a measure that counts rows where a column is not blank and greater than 100.

Power BI

CountValid = COUNTROWS(FILTER(Table, NOT(ISBLANK([1])) && [2] > [3]))

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

ATable[Score]

C100

D50

Attempts:

3 left

💡 Hint

Common Mistakes

Using different columns in blanks 1 and 2.

Using 50 instead of 100 for comparison.

Not using NOT(ISBLANK()) correctly.

The measure filters rows where Table[Score] is not blank and greater than 100, then counts those rows.