Filter Context - The Whiteboard #01

[@bms4654]

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.

[@juliane1mota]

Very Good Marco!!! The refinement and elegance of your explanations are unmatched!

[@sbn4862]

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.

[@ahmedkamiss7643]

Finally, it's getting through my thick skull.... thank you!❤

[@eziola]

Love the Whiteboard! Keep em coming!

[@rizkyramdhany4549]

This explanation is easy to understand. Thanks!!

[@williamarthur4801]

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.

[@gabrieldenoury5863]

Love this new format!

[@philipmathew6542]

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.

[@Fernando_Calero]

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.

[@lmblancoancos]

Fantastic explanation. Thank you very much Marco for this series👍😊

[@Bremerhaven_Rocks]

Whenever I read the book: The Definitive Guide to DAX. I read it with an Italian accent.

[@tarekkhalefa1836]

Excellent way of representation 👌

[@fadydoc]

Perfect explanation....Thank you so much for the amazing content.

[@zoranmilokanovic6229]

Come sempre Marco sei bravo!

[@johansantacruz6464]

Nice and detailed explanation! Plese keep going with this great material for us.

[@1yyymmmddd]

Great video. Will be waiting for the follow up with ALLSELECTED.

[@ExcelUpNorth]

That was very well explained. Makes much more sense now. Thank you!

[@meshalnafea5200]

Great Video!!

[@jhormangomez2268]

Beautiful

[@laviedandre]

This is excellent‼️

[@PJJACOB360]

You are the best.

[@michafabich9213]

perfect series

[@就已]

Amazing

[@Lotaristo]

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.

[@imadbabbili]

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

[@mariusnavickas3129]

Thank you! :)

[@javierar87]

THIS is the way

[@rodrigocorrea6348]

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!

[@SQLBI]

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/

[@Jonny231188]

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.

[@ajaysuresh8856]

Cool

[@sayananalytics3445]

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?

[@marcorusso7472]

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.

[@sandeepbarge4699]

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"))

[@SQLBI]

See www.sqlbi.com/articles/filter-arguments-in-calculate/

[@trilokinathsingh5705]

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).

[@SQLBI]

Use this: www.sqlbi.com/guides/dax/

[@robertalavezzari6970]

killing me softly with this DAX ..........

[@baruchlunabarber7170]

Nice format, would like to know what tools were used to create this format, thank you.

[@SQLBI]

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

[@karannchew2534]

CALCULATE ( Measure, REMOVEFILTER ( Table[Col] // All ( Table[Col] ))

[@manideep8566]

Make a video on Expanded Tables in DAX as part of this series.

[@SQLBI]

It's already planned, see www.sqlbi.com/blog/marco/2022/07/14/the-whiteboard-video-series-on-sqlbi-youtube-channel/

[@manideep8566]

Ohh great!

[@The_Code_Father]

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

[@SQLBI]

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.

[@The_Code_Father]

@@SQLBI thank you sir I learned a lot from you ☺️

[@IoriYagamiKOF98]

First Comment!!!! :D