Hi Goodly, I'm only roughly a month into Power BI and DAX and you've already been a tremendous help with your videos. Thank you! I'm not a big fan of this particular video however, as I think the concept of ALLSELECTED() is not that difficult to understand, but you're making it quite complicated with your definition and the way you go at explaining it with the matrix. The definition I go by is: ALLSELECTED() provides the grand total for the externally (Slicer-) selected values of the (one or more) dimension column(s) specified in the ALLSELECTED() function, ignoring any filters for that/those dimension column(s) coming from the displaying visual. Or even better: ALLSELECTED() is simply the dynamic version of a hard coded dimension filter within CALCULATE():
i.e. = CALCULATE([Total Sales],ALLSELECTED('Article'[Color])) - with an external filter on [Color] selecting "red" and "blue" equals the non dynamic code: =CALCULATE([Total Sales], 'Article'[Color] in {"red",blue"})
ALLSELECTED() with more than one column or the entire table then wraps the specified columns or all the columns in the specified table in an AND() function.
i.e. =CALCULATE([Total Sales], ALLSELECTED('Acticle'[Color]), 'Article'[Category])) - with an external filter on [Color] selecting "red" and "blue" and an external filter on [Category] selecting "Bikes" and "Safety Equipment" equals the non dynamic code: =CALCULATE([Total Sales], AND('Article'[Color] in {"red", ”blue"), 'Article'[Category] in {"Bikes", "Safety Equipment"})) Best TheRealNucleus
Thnx for ur efforts. I have an intriguing question with regards to "filter restoration". Marco/Alberto mention in one of their videos on ALLSELECTED that it restores filters from outside of visual hence, in our case here, year should not be filtering the data at all since its inside the visual(Matrix). Pls shed some light on this. Again gr8 work and keep helping us understand DAX :)
The specific example that Marco or Alberto discussed could have the scenario. I really need to see that video to clarify ALLSELECTED simply restores the values of the columns that you mention inside the function. Of course, the best way is to try it out yourself :)
@@GoodlyChandeep Thx for replying. My concern is when u say ALLSELECTED with NO parameter when used in CALCULATE restores all filters. However, as per Following description frm Alberto, it seems only filters from outside of current visual are restored which in your case is only category & color coming from slicers hence, why are date columns also restored. Following is a 4 min video from Alberto th-cam.com/video/UehWR5wWWEo/w-d-xo.html
Great video, I do think a lot of DAX functions are badly named, so; ALL ; returns a table of unique values and sees no filters, VALUES sees them all , but ALL-selected restores them, likewise Keepfilters is really enforcing an AND between internal and external. I think?????
HI CHANDEEP What it meens -Last visiable shadow context filter? I understund it so. Last visable-A Column in the matrix as Catigory it's current context filter and the sliser it's a last context filter. Shadow context filter created by the sliser restoring current context filter. Or NOT?
ALLSELECTED FUNTION TAKES THE OUTER FILTER CONTEXT RATHER THAN THE INSIDE---ALBERTO ALLSELECTED FUNCTION TAKES THE CLOSEST FILTER CONTEXT ---GOODLY , I am confused now, Is my understanding correct?
Dear sir , I think either i am not getting or some issue. . Although what you explain is perfectly right but . .I think that the way you are interpreting shadow filter context is not correct . .Shadow filter context is specifically used when all selected is inside an iterator . . You are using shadow filter word loosely for both explicit and shadow filter . Also You have not covered the nuance of main trickey area of allselected that is all selected inside iterator or multiple iterator. .
The best explanation of the topic, on all of TH-cam.
Hi Goodly,
I'm only roughly a month into Power BI and DAX and you've already been a tremendous help with your videos. Thank you!
I'm not a big fan of this particular video however, as I think the concept of ALLSELECTED() is not that difficult to understand, but you're making it quite complicated with your definition and the way you go at explaining it with the matrix.
The definition I go by is:
ALLSELECTED() provides the grand total for the externally (Slicer-) selected values of the (one or more) dimension column(s) specified in the ALLSELECTED() function, ignoring any filters for that/those dimension column(s) coming from the displaying visual.
Or even better:
ALLSELECTED() is simply the dynamic version of a hard coded dimension filter within CALCULATE():
i.e. = CALCULATE([Total Sales],ALLSELECTED('Article'[Color]))
- with an external filter on [Color] selecting "red" and "blue" equals the non dynamic code:
=CALCULATE([Total Sales], 'Article'[Color] in {"red",blue"})
ALLSELECTED() with more than one column or the entire table then wraps the specified columns or all the columns in the specified table in an AND() function.
i.e. =CALCULATE([Total Sales], ALLSELECTED('Acticle'[Color]), 'Article'[Category]))
- with an external filter on [Color] selecting "red" and "blue" and an external filter on [Category] selecting "Bikes" and "Safety Equipment" equals the non dynamic code:
=CALCULATE([Total Sales], AND('Article'[Color] in {"red", ”blue"), 'Article'[Category] in {"Bikes", "Safety Equipment"}))
Best TheRealNucleus
superb explaination
👏 👏
👏 👏
👏 👏
👏 👏
👏
One of the best 17 minutes I have spent on DAX ever.. Thanks for explaining in such details
These videos are the bestes that i have found so far in youtube or anywhere ...thanks a lot for educating us in such a great way :)
Glad you like them!
Dude, you are not a hero but THE hero!
Big words.. thanks buddy!
Superb explanation of this tricky DAX function. Love the different examples that clearly explain it step by step.
mind blowing explanation.
You did a great job to explain one of the most complicated functions in DAX.
Thanks Man.. I am glad you found it helpful
Best Explanation Mann on TH-cam !!!
Thnx for ur efforts. I have an intriguing question with regards to "filter restoration". Marco/Alberto mention in one of their videos on ALLSELECTED that it restores filters from outside of visual hence, in our case here, year should not be filtering the data at all since its inside the visual(Matrix). Pls shed some light on this. Again gr8 work and keep helping us understand DAX :)
The specific example that Marco or Alberto discussed could have the scenario. I really need to see that video to clarify
ALLSELECTED simply restores the values of the columns that you mention inside the function. Of course, the best way is to try it out yourself :)
@@GoodlyChandeep Thx for replying. My concern is when u say ALLSELECTED with NO parameter when used in CALCULATE restores all filters. However, as per Following description frm Alberto, it seems only filters from outside of current visual are restored which in your case is only category & color coming from slicers hence, why are date columns also restored. Following is a 4 min video from Alberto th-cam.com/video/UehWR5wWWEo/w-d-xo.html
Amazing...you explained it very well
Well explained mate.
Keep up the good work. thanks
Video is God Sent 🙌🏻
Hi I want be expert on power bi ,just have etl understanding as of now. Which playlist I should start with of yours?
Great explanation
Perfect! Thank you.
Glad you like it 😊
Great video, I do think a lot of DAX functions are badly named, so; ALL ; returns a table of unique values and sees no filters, VALUES sees them all , but ALL-selected restores them, likewise Keepfilters is really enforcing an AND between internal and external. I think?????
HI CHANDEEP
What it meens -Last visiable shadow context filter?
I understund it so.
Last visable-A Column in the matrix as Catigory it's current context filter and the sliser it's a last context filter.
Shadow context filter created by the sliser restoring current context filter.
Or NOT?
Loved it. Learnt a lot in terms of the working of function. Can you please do a video on SELECTEDVALUE & HASONEVALUE functions, please?
Selectedvalue is right here - th-cam.com/video/tVpevJEq2sg/w-d-xo.html
@@GoodlyChandeep Thank you :)
Hey have you explained ALL function in DAX if yes please share link as i cant find it
Hope TH-cam pays for the several subsequent viewing time after the first one. ❤
My All Selected is not working on two column. I am unable to retrieve intellisence for second column. Kindly assist.
So visible means on visual or on filter ???
Good Stuff
Glad you enjoyed!
ALLSELECTED FUNTION TAKES THE OUTER FILTER CONTEXT RATHER THAN THE INSIDE---ALBERTO
ALLSELECTED FUNCTION TAKES THE CLOSEST FILTER CONTEXT ---GOODLY , I am confused now, Is my understanding correct?
Dear sir , I think either i am not getting or some issue. . Although what you explain is perfectly right but . .I think that the way you are interpreting shadow filter context is not correct . .Shadow filter context is specifically used when all selected is inside an iterator . .
You are using shadow filter word loosely for both explicit and shadow filter .
Also You have not covered the nuance of main trickey area of allselected that is all selected inside iterator or multiple iterator. .
pls keep explanation simple