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.
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?
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.
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.??
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]
Declare SELECTEDVALUE as variable and use the Variable inside the FILTER, it should work! And you are right about the evaluation of Selectedvalue should be done prior to the filter function.
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.
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.
Hey Chandeep, it seems the selected value function is not available on excel power pivot. I can only see "All Selected" and "Select columns". Please advise...
@@GoodlyChandeep bingo I got what I wanted. I was trying to change💱 the pivot value using selected currency available in slicer. You saved me in not using a macro. Thanks a ton. 👍👍👍👍👍👍❤️❤️❤️❤️
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.
Thank you very much. By far, the best explanation i had about this topic.
I have gone through a couple of videos in this series... Such complex things are made simple. fantastic bro... keep it up.
Thanks a ton.. keep watching :)
I like how you used simple table for the data and showed filter context of SELECTEDVALUE
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?
thank you very much sir... many things i learnt from your videos
Thanks Chandeep , you make it easy to understand the DAX💗
Glad it was helpful!
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.
Thanks goodly you are really good
your explanation always impresses me
Thanks Hoài !
Really , this helped me alot ❤ thanks for such beautiful video
Glad it was helpful Lily!
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.??
Your content is like Bible for someone who's trying to learn Power BI
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]
Declare SELECTEDVALUE as variable and use the Variable inside the FILTER, it should work!
And you are right about the evaluation of Selectedvalue should be done prior to the filter function.
Thumbs up!! Keep up the good work!!
Thank you.. Glad you found it helpful
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.
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.
Sir how to achieve the requirement:
Table should display values greater than the value selected in filter slicer
Nice video. Thank you:)
Glad you liked it!
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.
There is no change in Power Pivot.. it's exactly the same!
Hey Chandeep, it seems the selected value function is not available on excel power pivot. I can only see "All Selected" and "Select columns". Please advise...
@@excel-k-sir Try this DAX as an alternative
=IF(HASONEVALUE(Table[ColumnName]),MAX(Table[ColumnName]))
@@GoodlyChandeep bingo I got what I wanted. I was trying to change💱 the pivot value using selected currency available in slicer. You saved me in not using a macro. Thanks a ton. 👍👍👍👍👍👍❤️❤️❤️❤️
why in this case a switch true is not required?
With selected value can we use all functions?
wgy do you talk so fast, yse Value as aheading and talk about actual value and jump throught things ???
not comfortable to see . plz zoom the display, bcz, it look small when you r write DAX..
Didn't understand