SELECTEDVALUE and HASONEVALUE in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

Understanding SELECTEDVALUE with multiple selections

Given a slicer on the 'ProductCategory' column with multiple categories selected, what will the following DAX measure return?

Selected Category = SELECTEDVALUE('Product'[ProductCategory], "Multiple")

Power BI

Selected Category = SELECTEDVALUE('Product'[ProductCategory], "Multiple")

A "Multiple"

B The first selected category

C Blank

D Error

💡 Hint

Think about what SELECTEDVALUE returns when more than one value is selected.

SELECTEDVALUE returns the single selected value if only one is selected. If multiple values are selected, it returns the alternate result, here "Multiple".

❓ dax_lod_result

intermediate

Using HASONEVALUE to check filter context

What will the following DAX expression return when the report is filtered to exactly one 'Region'?

Is Single Region = HASONEVALUE('Sales'[Region])

Power BI

Is Single Region = HASONEVALUE('Sales'[Region])

A Blank

B FALSE

C TRUE

D Error

💡 Hint

HASONEVALUE returns TRUE only if exactly one distinct value is in the current filter context.

Since the report is filtered to exactly one 'Region', HASONEVALUE returns TRUE.

❓ visualization

advanced

Visualizing dynamic titles with SELECTEDVALUE and HASONEVALUE

You want to create a dynamic title for a report page that shows the selected 'Year' if only one year is selected, or "Multiple Years" if more than one year is selected. Which DAX measure correctly achieves this?

A Title = IF(COUNTROWS(VALUES('Date'[Year])) > 1, "Multiple Years", SELECTEDVALUE('Date'[Year]))

B Title = SELECTEDVALUE('Date'[Year], "Multiple Years")

C Title = IF(HASONEVALUE('Date'[Year]), "Multiple Years", SELECTEDVALUE('Date'[Year]))

D Title = IF(HASONEVALUE('Date'[Year]), SELECTEDVALUE('Date'[Year]), "Multiple Years")

💡 Hint

HASONEVALUE checks if exactly one value is selected. SELECTEDVALUE returns that value or alternate.

Option D correctly uses HASONEVALUE to check for a single year and returns that year; otherwise, it returns "Multiple Years".

🔧 Formula Fix

advanced

Debugging unexpected blank result with SELECTEDVALUE

A measure uses SELECTEDVALUE to get the selected 'Customer'[Name], but it returns blank even when one customer is selected. What is the most likely cause?

Power BI

Selected Customer = SELECTEDVALUE('Customer'[Name])

A The 'Customer'[Name] column has duplicate values causing SELECTEDVALUE to return blank

B The filter context includes multiple customers, so SELECTEDVALUE returns blank

C The 'Customer'[Name] column is not loaded in the data model

D The measure syntax is incorrect and causes a runtime error

💡 Hint

SELECTEDVALUE returns blank (no alternate specified) if the filter context has more than one distinct value for the column.

Even when one customer appears to be selected, the filter context likely includes multiple customers (e.g., due to other slicers, cross-filters, or visual interactions), resulting in multiple distinct values for 'Customer'[Name].

🧠 Conceptual

expert

Choosing between SELECTEDVALUE and HASONEVALUE in complex filters

In a report with multiple slicers and complex filter context, which statement best describes the difference between SELECTEDVALUE and HASONEVALUE?

A SELECTEDVALUE returns the single selected value or alternate; HASONEVALUE returns TRUE if exactly one distinct value exists in filter context

B SELECTEDVALUE returns TRUE or FALSE; HASONEVALUE returns the selected value or alternate

C SELECTEDVALUE and HASONEVALUE always return the same result in any filter context

D SELECTEDVALUE returns all selected values concatenated; HASONEVALUE returns the count of selected values

💡 Hint

Think about what each function returns and their purpose in filter context evaluation.

SELECTEDVALUE returns the single selected value or an alternate if multiple or none are selected. HASONEVALUE returns TRUE if exactly one distinct value exists in the filter context, otherwise FALSE.