Filter Context - The Whiteboard #01
ฝัง
- เผยแพร่เมื่อ 5 ต.ค. 2024
- 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/...
#thewhiteboard - วิทยาศาสตร์และเทคโนโลยี
![[LIVE] : ONE ลุมพินี 82 วันนี้!! คู่เอก | ยอดไอคิว vs อับดัลลาห์](http://i.ytimg.com/vi/hSsyTl_9bqs/mqdefault.jpg)
Whenever I read the book: The Definitive Guide to DAX. I read it with an Italian accent.
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.
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.
Finally, it's getting through my thick skull.... thank you!❤
Very Good Marco!!! The refinement and elegance of your explanations are unmatched!
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.
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.
Fantastic explanation. Thank you very much Marco for this series👍😊
This explanation is easy to understand. Thanks!!
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.
Love the Whiteboard! Keep em coming!
Great video. Will be waiting for the follow up with ALLSELECTED.
Perfect explanation....Thank you so much for the amazing content.
Love this new format!
That was very well explained. Makes much more sense now. Thank you!
Nice and detailed explanation! Plese keep going with this great material for us.
Excellent way of representation 👌
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.
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
Beautiful
perfect series
Come sempre Marco sei bravo!
Thank you! :)
This is excellent‼️
You are the best.
Great Video!!
THIS is the way
Amazing
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/
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.
Cool
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/
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.
killing me softly with this DAX ..........
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 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 ☺️
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/
CALCULATE (
Measure,
REMOVEFILTER ( Table[Col]
// All ( Table[Col]
))
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!
First Comment!!!! :D