Capturing Slicer Selections with SELECTEDVALUE

1. Understanding the SELECTEDVALUE Function

At its core, SELECTEDVALUE is a simple yet powerful function. Its purpose is to check if a single, unambiguous value has been selected for a given column in the current filter context.

• If one value is selected (e.g., a user clicks "Canada" in a country slicer), the function returns that value.
• If multiple values or no values are selected, it returns a blank or an optional default value that you can specify.

This function is essentially a more readable and convenient way of writing a common, older DAX pattern. To understand the theory behind it, please watch the following video from the experts at SQLBI.

As the video explains, the syntax for SELECTEDVALUE is:

SELECTEDVALUE ( <columnName>[, <alternateResult>] )

The <alternateResult> is optional, but it's a best practice to provide one to control what your visuals display when no single selection is made.

For a detailed text reference, you can consult the companion article from SQLBI.

2. Capturing a Slicer Selection: A Practical Example

Now, let's move from theory to practice. You will create a measure to capture a user's selection from a slicer and display it on the report canvas.

Follow these steps in your Power BI project file:

1. Add a Slicer: Add a new slicer to your report page and drag the Product[Category] field into it.

2. Create the Measure: Create a new DAX measure with the following code. Here, we'll capture the selected category name, and if no single category is selected, we'll return the text "Multiple Categories".

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

3. Display the Measure: Add a Card visual to your report and drag your new [Selected Category] measure into it.

Now, interact with the slicer you created:

• With nothing selected: The card should display "Multiple Categories".
• Select "Bikes": The card should update to show "Bikes".
• Hold CTRL and select "Accessories": The card should revert to "Multiple Categories" because more than one value is now in the filter context.

The following resource provides a simple, visual walkthrough of this exact process. While you've already built it, reviewing this can reinforce the concept.

3. Using the Captured Value to Control Calculations

Displaying the selected item is useful, but the real power comes from using that selection to drive other calculations. For example, you might want to show a detailed calculation only when a user has drilled down to a single item.

Let's see how to combine SELECTEDVALUE with an IF statement to achieve this. The video below provides an excellent demonstration.

Let's apply this pattern to our data. Create a new measure that calculates [Total Sales] but only if a single Product Category is selected.

Sales for Selected Category = 
-- This measure returns Total Sales only if one category is selected.
-- Otherwise, it returns BLANK().
VAR SelectedCategoryName = SELECTEDVALUE('Product'[Category])
RETURN
    IF(
        NOT ISBLANK(SelectedCategoryName),
        [Total Sales],
        BLANK()
    )

Add this new measure to a card visual. You will see that the card only shows a sales value when you select a single category in your slicer. In all other cases, it will be blank. This is an extremely common pattern for guiding users and preventing aggregation at levels that don't make business sense.

Conclusion

In this lesson, you've learned how to use SELECTEDVALUE to make your reports aware of user selections. This is the first and most critical step toward building truly interactive and dynamic dashboards.

Key Takeaways:

• SELECTEDVALUE returns a value from a column only when that column has a single, unambiguous value in the current filter context.
• It's best practice to provide the optional alternate result to handle cases where zero or multiple items are selected.
• SELECTEDVALUE is a modern, readable replacement for the IF(HASONEVALUE(...), VALUES(...)) pattern.
• The real power of SELECTEDVALUE is unlocked when you use its output to control other functions, like IF or SWITCH, to create conditional calculations.

Preview of the Next Lesson:

We've now successfully used SELECTEDVALUE with a simple IF statement. In the next lesson, we will take this to the next level. You'll learn how to use it with the SWITCH function to create a "measure switcher"—a single, powerful measure that can perform several different calculations (e.g., show Total Sales, Total Profit, or Quantity) based on what the user chooses from a slicer.