• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Resources
    • DAX Glossary
    • Download Center
    • Template Apps
    • Data Stories Gallery
    • Solution Gallery
    • Learning Resources
  • Courses
    • Introduction to Power BI – FREE Online course
    • Power Query Online Training for Power BI
    • M Language Online Course: The unofficial and Practical Reference Guide
  • Blog
  • Shop
    • Courses
    • Swag
    • Template Apps
    • Donations
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / SELECTEDVALUE

SELECTEDVALUE

posted on December 5, 2017

« Back to Glossary Index

Syntax

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

Tutorial with example

In today’s video, we will go through the DAX function SELECTEDVALUE. SELECTEDVALUE is syntax sugar for IF(HASONEVALUE(VALUES))

Link to Northwind dataset: https://www.youtube.com/watch?v=k3NMI…

Download example file:

The file is available for download here.

Example 2:

In today’s #daxfridays video I will show you how to get selected or multiple values from a slicer:

Download example file:

Download Power BI file: here.

Remarks

An equivalent expression for SELECTEDVALUE(<columnName>, <alternateResult>) is IF(HASONEVALUE(<columnName>), VALUES(<columnName>), <alternateResult>).

Was this helpful?
[Total: 4   Average: 4.8/5]
« Back to Index

Reader Interactions

Comments

  1. rawatvikas00

    May 16, 2019 at 12:02 pm

    Hi ruth, can you show how to show comma separated values in card upon multiple selection i.e. – A, B

    Reply
  2. Waheed

    January 7, 2019 at 9:37 pm

    I can’t download the examples file
    Please, help

    Reply
    • Ruth Pozuelo Martinez

      January 7, 2019 at 9:57 pm

      All files have moved to the download center, please download it from there.
      /Ruth

      Reply

Let us know your thoughts... Cancel reply

Footer CTA

Join our community of +20,000 professionals

Become a Member

Subscribe to YouTube

About us

Curbal AB
Kopparbergsvägen, 10
722 13 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2021 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In