DAX Fridays! #49: SELECTEDVALUE

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

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

ABOUT CURBAL:

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo

#daxfridays #curbal #SUBSCRIBE

[BilalZia]

Hey Ruth. Thanks for the updated knowledge.

[gokulakrishnansubramaniam]

Can we use selected value for multiple items in same filter

[rrrprogram]

Great as usual... thanks for the new function

[excelisfun]

7*7 = 49, but I am still waiting for the big surprise in #50!!! Thanks for the SELECTEDVALUE : )

[srividhyasubramony]

Thank you

I tried selected value on a date slicer. I tried to do comparison with date field . This say s date and text cannot be compared.
Does selectedvalue return text value

[getusama]

Hi


Please, could you the powerbi file for this. I would very interested to see how you are actually calculating the Ranks and Passing the values.

[glennmartinez]

Thank you for this and the other tutorials on Power BI. On your website, I tried to access the example file but couldn't access the "DAX Fridays downloads" section.

[sudhakark]

Hi can you please help on my issue
I have t1, t2, t3, t4 tables and t5 having mentioned 4 tables as column values.
I'm using t5 as slicer, Wn ever click t5 values respective table count should display in measure
Var v1=selectedvalue(t5)
Return
If(v1=t5 value(if I select t4 name), calculate(count(t4(col1), col1), OK)
This working fine, but Wn ever I click date slicer it's showing blank
Please let me know
Thanks in advance

[thyang]

Your content is so great Ruth. I have a suggestion that you can summarize what you have done step by step in the description box, that would be awesome!!!

[BigDataSport]

File has broken link! thanks in advance

[siddheshamrutkar]

Hello Ruth any videos on CustomData function of DAX please?

[frankgovers]

Hi Ruth, great... thanks. One to go
When will you explain the curbal name??

[flislander]

Determining the Top values is straight forward. Finding the bottom performers can be more difficult. Can you do a video on the Bottom 3, 5 or 10 worst products, sales people, customer etc. Thanks

[santosomarcabrerapadilla]

disculpa agregar subtitulo a los videos. im from Honduras