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
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?
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. .
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?
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?????
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UehWR5wWWEo.html