Filter Context - The Whiteboard #01
Вставка
- Опубліковано 13 лип 2022
- Introduce the filter context in the first episode of The Whiteboard!
Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more: www.sqlbi.com/blog/marco/2022...
#thewhiteboard - Наука та технологія
Finally, it's getting through my thick skull.... thank you!❤
This is a really good way to teach DAX. It would be great to apply this break down to increasingly complete formulas. You guys are a major corner stone in my DAX learning and I thank you for the time you put into your content.
Whenever I read the book: The Definitive Guide to DAX. I read it with an Italian accent.
Very Good Marco!!! The refinement and elegance of your explanations are unmatched!
Bravo, You both explain the 'nuts and bolts ' of DAX better than anyone, I'm just up to 'Evaluation order in Calculate' in THE BOOK. keep up good work.
Context Filter, Context Transitions, Implicit Filters, Nested Filters...Removing Old Filter, Unite Old and New Filters. Step by Step it's going easier. Thank you.
This explanation is easy to understand. Thanks!!
Nicely explained. So I surmise that in Filter context...values are taken from different tables and put into the virtual table as per the measure.....thank you.
Love the Whiteboard! Keep em coming!
Fantastic explanation. Thank you very much Marco for this series👍😊
Excellent video, thank you very much Marco! Back to basics. Understanding these concepts will set the base for all the rest and more complex topics.
THIS is the way
Perfect explanation....Thank you so much for the amazing content.
Nice and detailed explanation! Plese keep going with this great material for us.
Love this new format!
That was very well explained. Makes much more sense now. Thank you!
Great video. Will be waiting for the follow up with ALLSELECTED.
Excellent way of representation 👌
Come sempre Marco sei bravo!
You are the best.
Good format, even though these things are pretty basic it may be a hard thing for beginners, so thanks for such a good way of explaining.
This is excellent‼️
perfect series
Great Video!!
Beautiful
Great job Marco, it gives us a great insight of Dax.
I wonder why I have the playlist in a descending order (session 12, 11, 10, ....01
Cool
Thank you! :)
Amazing
Hi, thank you very much for the great video.
Is there a DAX Expression which shows how different outer filters change the result of the measure?
After watching your videos on the filter context and reading the article I thought that if I have a card visual (so no filter context within the visual itself) and an outer filter applied to it leads to the same result as not having the outer filter and adding FILTER( ALL( ) , ) to the measure instead. But that seems not to be the case.
Thank you for this amazing content!!!
I found your explanation quite nice but I thought that *CALCULATE* overwrites the outer filter context and you mentioned in this example that it adds to the outer (or existing filter context). I am referring to the minute 4:19. In case I try to reproduce your example, I would imagine that all the rows of my matrix/table would return the same result. It's very possible that I am not understanding *CALCULATE* properly and if one could answer, I would appreciate it.
Thank you again for all the material you share!
CALCULATE defines a filter context for computing an expression - the filter context is created starting from the existing one, but the effects of CALCULATE don't propagate outside of CALCULATE. Start studying CALCULATE here and then in other training material linked at the end of the article: www.sqlbi.com/articles/introducing-calculate-in-dax/
killing me softly with this DAX ..........
Hello Marco..Great Video...Can you please tell us which pen you are using? And your monitor is also cool. Do you have any article published regarding that just like Alberto's article?
I have a similar configuration. In this video, I use a Surface Studio with its pen - the software is the free Microsoft Whiteboard available on the Windows Store.
Hi Marco,
Thanks for starting this wonderful series. You guys are doing great service to Power BI community. Thanks!
Can you please explain difference in the way following 2 formulae works in your way of explaining? Because output differs. I also want to know how come first formula below allows code to access Color column because row context introduced by SUMX function is ended in first argument of CALCULATE function itself? What am I missing here? Please please please reply.
CALCULATE(SUMX(Sales, Sales[Quantity]), 'Product'[Color]="Red")
and
CALCULATE(SUMX(Sales, Sales[Quantity]), FILTER('Product', 'Product'[Color]="Red"))
See www.sqlbi.com/articles/filter-arguments-in-calculate/
Nice format, would like to know what tools were used to create this format, thank you.
The Microsoft Whiteboard, which is a free app in the Windows Store: apps.microsoft.com/store/detail/microsoft-whiteboard/9MSPC6MP8FM4?hl=en-us&gl=US
I am new user from India (Delhi), please let me know from which video of Dax to start first for DAX, means serial wish list (Index).
Use this: www.sqlbi.com/guides/dax/
First Comment!!!! :D
Make a video on Expanded Tables in DAX as part of this series.
It's already planned, see www.sqlbi.com/blog/marco/2022/07/14/the-whiteboard-video-series-on-sqlbi-youtube-channel/
Ohh great!
CALCULATE (
Measure,
REMOVEFILTER ( Table[Col]
// All ( Table[Col]
))
I think this tutorial needs to be a little bit longer to be more beneficial coz i watched all of it but I don't feel satisfied enough about it
But great work anyway keep it up marco
The goal is to provide additional material with another point of view, not to replace existing content. Thus, also the video length is not that long, otherwise it would overlap the existing content in our courses and videos.
@@SQLBI thank you sir I learned a lot from you ☺️