SELECTEDVALUE Function in DAX

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

[pravinshingadia]

Chandeep - thank you for your great work. I'm currently in hospital with an illness and using the time to work through your videos. They have kept my mind sharp and when I leave will be leaving a better and more skilled person.

[SiamData]

Fast and effective explanation. Keep up the work man. Love your videos. Learnt so much from your videos

[fabiocardososantos]

Thank you very much. By far, the best explanation i had about this topic.

[raghavendrabatchu]

I have gone through a couple of videos in this series... Such complex things are made simple. fantastic bro... keep it up.

[rajeshn]

thank you very much sir... many things i learnt from your videos

[shahadatshajjat]

Thanks Chandeep, you make it easy to understand the DAX💗

[lilyfullery]

Really, this helped me alot ❤ thanks for such beautiful video

[hafizasim]

I normally use this for period selection i.e. Q1 Q2 Q3 Q4 or for month dimension. How to use this if I want to select Multiple periods i.e. Q1 and Q2 for example?

[theperpetuallyannoyed]

if i have a card and a table. the card will show the first value in the given column but i want to show default value on the card as something else and only want to show the value when i select something on the table. how can i do this.??

[MilhouseBS]

I like how you used simple table for the data and showed filter context of SELECTEDVALUE

[getntertain]

Brother, how I can filter my custom table using SELECTEDVALUE. For instance, I want to list only those country who played against SELECTEDVALUE country slicer. I would be grateful if you answer these query as I did not find this solution anywhere.

[ardenzhuo]

why in this case a switch true is not required?

[Laxmanmane]

Hi chandeep, I am planning to do prepration of power bi certification could you please provide all details of that exam, how to prepare, cost etc.

[Excel-power-users]

Hey Chandeep, thanks for explaining so nicely. Since the whole session was on measures I assume this is possible in power pivot too. If so then a small request from my side to show this type of session from power pivot perspective too.

[varunjain]

With selected value can we use all functions?

[anuragbawankar]

Sir how to achieve the requirement:
Table should display values greater than the value selected in filter slicer

[pcjrtube]

Thanks for sharing this video. I have a question: Do you know why SELECTEDVALUE() does not work inside a FILTER() to slice a table?

I think the problem is that the SELECTEDVALUE () function is not evaluated before FILTER ().

Explaining further:

I'm trying to use the formula:
filtered_data =
FILTER (data, data [value] <= SELECTEDVALUE (Percentile [Percentile_Value]))
to create a table on a report page.

On the other hand, if I don't use SELECTEDVALUE (), that is, for example:
filtered_data = FILTER (data, data [value] <= 13.2)
then I get the expected result: only the table rows with data [value] <= 13.2.

[Adeyeye_seyison]

Thanks for ALL you do and give out. Your contents are life enhancing and skills upgrading.

Pls sir, I have a problem on data cleaning I would love to have you help me look into.

Please can you give me your email handle to forward it or any other channel you deem appropriate.

Thanks a million sir.

[MrRohanroxx]

Your content is like Bible for someone who's trying to learn Power BI

[pvarunkumar]

not comfortable to see . plz zoom the display, bcz, it look small when you r write DAX..