#2 DAX Fridays! 101: Introduction to filter and row context

[@oritogunfemi1041]

1 min from the beginning of this session, I fell in love with your style of teaching. Well articulated. Even the dumbest of all would understand it.

[@CurbalEN]

Thanks !!!

[@mohammadazadi3616]

perfect,perfect and perfect.The easiest to understand filter and row context . I had seen several tutorials on this subject before, but this video was really simple and understandable. Thanks a lot

[@ramvsrk]

Hi Mohammad, can you help me on getting the data. Though i know how to import to data, i don't know where this Orders, Customers, Product tables are present.

[@SaniGarba]

Most digestible content on CONTEXT that I have come across. Thank you, Ruth. The simplicity of this context principle is the reason why it appears so complicated. Your approach demystifies DAX. Again, thank you.

[@CurbalEN]

Happy it is useful Sani! /Ruth

[@Freemachains]

OMG !!! i v been stick for the last weak trying to filter a measure with calculate function , and all it was needed is to do it by calculated column , it's 2 AM right now and i finally got what i was looking for thanks to you !

[@ashaoluayanfe7474]

I love your style of teaching: fun, engaging and educating.

[@CurbalEN]

Thanks!

[@ayobamiologun9184]

Ruth is simply awesome with the way she doles out her knowledge. God bless you.

[@CurbalEN]

Thanks Ayobami and Happy Friday!! /Ruth

[@matthewclarke2899]

yes, excellent teacher, clear, concise, good speed, good examples, and relaxed style

[@CurbalEN]

Thanks Matt! /Ruth

[@khalidrasheed7724]

beautifully explained. you are teacher by your nature.

[@rpv1494]

Nice Job, very clear and your enthusiasm is affectious.

[@claurecoba11]

The 101 Series is awesome, they are a lot of different topics that need to be understood in order to build something consistent. I haven't watched all your DAX Friday series yet (and I will..) but I think this type of videos help us to understand why things happen as they do, this is SO IMPORTANT. Also, they are many real-life situations that are very complicated to solve when you don't know which DAX formula, modeling strategy or even a simple tip are needed to point you in the right direction. A particular case that I haven't seen anywhere it's about the use of USERELATIONSHIP to filter by many date fields (that part it's out there) but no one tells you that if one of the dates has time and the other doesn't (12:00 AM by default), the USERELATIONSHIP does not work between those related columns! I can´t leave without saying that before the video was over I had to know if I could get some "Queso Cabrales" in my country.

[@CurbalEN]

First of all, thanks for the awesome review, really appreciate it :) I will continue with the DAX101 series building on concepts and adding difficulty to them, but to do it well, I need time, so it will take time until I have all of them published. Now, to the most important part of all: where do you live so I can direct you to a sales point for queso cabrales in your country 😂😂😂 /Ruth

[@claurecoba11]

@@CurbalEN Take your time to keep making great content we can wait. I'm from Uruguay!

[@CurbalEN]

Ah, Saludos!! :) /Ruth

[@CurbalEN]

Si les pides a estos a lo mejor te lo consiguen: www.nonnoantonio.com/quesos.html ;) /Ruth

[@claurecoba11]

@@CurbalEN Muchas gracias!!

[@Shib_ghosh]

Evaluation context is the most important part of DAX and in this video you have explained the topic very nicely. The explanation is very simple and insightful.. Thank you so much for all the effort you put to create these videos since there are limited resources available on DAX.❤️❤️

[@Prasoon.Chauhan]

The way you teach is like a mother teach her child, simply awesome 😊😊. Always ♥️ to see your videos at any time,and its 5 AM here in India 😋. Now i sleep in peace.

[@CurbalEN]

Sweet dreams 😴😴! /Ruth

[@techienomadiso8970]

Ooh my God 😍🙏 By the 6th minute you've already said the clarity I was looking for 😭 Thanks a lot ❣️❣️❣️

[@CurbalEN]

🥳🥳🥳

[@TroyLambert]

Coming from a business excel user's perspective - this is an easy to understand format - excellent job

[@CurbalEN]

We have the same background, so it might help ;) /Ruth

[@tak0331]

Good job Ruth! Great explanation.

[@therealcomment5622]

Splendid explanation and humor. Awesome!

[@osamaasif9601]

Ruth, this stuff is gold. Please keep it up.

[@CurbalEN]

Will try!

[@mePrafull]

Thank you for making the DAX concepts simple

[@hasnainhaider8191]

This video entails the most fundamental concepts that should be part of every beginner session on DAX, measure and column. I spent last 2 days, in working a measure right, and if I had known this earlier, it would've certainly helped.

[@CurbalEN]

Glad it helped!! /Ruth

[@cadurgeshagrawal]

Superb !!! Very Nicely explained and really get lot on insights from watching your videos... Good Job !!

[@ssma1368]

Wow! Ruth you are a brilliant teacher❤️

[@CurbalEN]

😊 Have a great weekend! /Ruth

[@michelcesar85]

Your videos are very clear and easy to understand, my favorite channel! Thanks for sharing knowledge! Greetings from Brazil!!!

[@CurbalEN]

Ohh, thanks!! 😊😊 o obrigada ;) /Ruth

[@michelcesar85]

@@CurbalEN Obrigada* perfect! I love!!! :D

[@rakahs5]

Amazing video, i have been struggling with this for a while. U have made this super simple. Thanks a lot.

[@CurbalEN]

Wonderful to hear and enjoy your weekend! /Ruth

[@junaidbagwan5523]

whenever I have difficulty understanding any DAX Function, I come here. Thanks for Sharing your knowledge in such simple and understandable way!

[@CurbalEN]

Pleasure to hear :) Ruth

[@vakfunnyfactstelugu9531]

Awesome.. clear and in detailed explanation, I got answers for so many questions..

[@CurbalEN]

Great! Glad it helped! /Ruth

[@fguihen]

Hi Ruth. Thank you for the fantastic resources, saved my bacon more than a few times! At 20:40 in the video, you say "sum does not do row by row, sumx does row by row". But...if i create a calculated column with SUMX(Sales,[Sales]), it still gives the total for the entire tables, exactly like SUM(Sales[Sales]). So even though SUMX is going row by row, it still does not give the intuitive answer I would expect. - In this case, is there truly a difference between SUM and SUMX? - If i put SUMX inside calculate, the answer is correct. is calculate imparting some default row context?

[@deedeec102]

I really really wish I had seen this video last year when you published it! Thank you soo much for your style and explaining from an Excel users perspective how/why it seems so different and it is also soo nice to know that I am not the only one confused! Love your explanation of the why and authenticity!

[@CurbalEN]

You are never alone when you feel confused while DAXing, be sure of that!!

[@TheAlgebraTeacherPOWERStoBI]

Great explanation! You're a natural teacher!

[@CurbalEN]

Thanks!😊

[@Maurici0GP]

Me encanta la explicación! Y debo admitir que la cara de trauma de "uy, ¿y ahora qué hice?" lo fue todo! :D jajaja

[@CurbalEN]

😂😂😂 Seguramente te llego al alma porque lo has sufrido tú también verdad? 😂😂😂 la monda! /Ruth

[@rick_.]

Hi Ruth, thank you for walking us through this.Oddly enough, you actually made something clearer to me that you didn't really explain in detail: why adding CALCULATE to a calculated column changed SUM from using the entire column to using the value for each separate row. CALCULATE changes the row context to an additional filter for that row and then the calculation is evaluated for each row's overall filter context. (I knew about context transition but I didn't really "get" it. Now I do!)

[@CurbalEN]

You are spoiling part 3!! ;) /Ruth

[@getusama]

@@CurbalEN hi Please can I have the link where it explains this

[@jianhongsong6140]

This is known as “context transition”.

[@joanneosborne2428]

Thank you for explaining this so that I can finally understand. I have struggled with this for a while and I appreciate your video' so much...You are the best!❤👍😊

[@CurbalEN]

Thanks Joanne, you too!!

[@poojasahasrabhojanee971]

You have to know your function :) You are amazing Ruth... Thank You so much :) :)

[@CurbalEN]

Thank you!! /Ruth

[@EricaDyson]

Very nicely explained. Well done, as usual. Thanks so much.

[@CurbalEN]

Thanks Erica!! More to come on the topic :) /Ruth

[@alanhernandez7201]

Hello Ruth, the hidden ALL function that you mentioned removes the filter of "Queso Cabrales", it removes the product names that don't belong to Queso Cabrales ? am i right? thantk you!

[@mangaldeep9544]

rip , rippped , ripfied ....superb 16:24 ... cut to the chase....u saved hell lotta my time

[@mangaldeep9544]

fantastic exlanation.......Superb !!!!

[@jasonwoodward5501]

A joy to watch. Thank you.

[@CurbalEN]

Wonderful! /Ruth

[@philipmathew6542]

Nicely explained....simple terms. Thank you

[@CurbalEN]

:)

[@KirillBezzubkine]

9:33 - CALCULATE's Filter Overrides General Filter. That s why there s only ONE number for QC product

[@trondlk]

Hi, I don't find all those fields in Northwind database. I downloaded Northwind from inside Access 2016, made a local copy on PC, and imported all tables into Power BI. But there's no fields like your at Sales or Product. Why so different?

[@walterben3111]

Hola, Ruth, thank you for these video, no more videos of 101 series? I found only #1 DAX Fridays! 101 and #2 DAX Fridays! 101...

[@CurbalEN]

Not yet, but I will :) /Ruth

[@walterben3111]

@@CurbalEN ok thank you, i can wait... till tomorrow :D In my opinion the 101 serie is estremely useful, gracias

[@Victor-ol1lo]

Excellent video Ruth !! I wish I would have seen this video three years ago... :-) For me personally the context tansition part was quite confusing, next to filter and row context in the beginning.... As always - Thumbs Up !

[@CurbalEN]

Weird to say this, but me too!! I truly hope it helps beginners get a quicker start in DAX. /Ruth

[@Truth-N-Lies]

Super Teacher. Very good explanation, you made me understand concepts, which I was looking as bigginer🌹

[@CurbalEN]

Wonderful to hear!

[@emmadkareem5247]

You have great desire to teach others. this is great. One remark is that you have to assume a certain level of the learner. If someone can't get what a filter is then this person will never (at this moment, at least) figure an Entity Relationship Diagram. My point is each course may require a number indicating the depth and the expected background of the student, otherwise it will be impossible for someone to use the material going forward. Thanks for the great effort you take.

[@CurbalEN]

Thanks for the feedback Emmad. It is really hard to categorize the level of a topic as depending on your background and how that person learns something that for somebody else is really easy can be advance for that person, you know what I mean? I have labeled things as beginners and advance before without much success and for that reason I let you guys decide the level after you seen the video. Hope it makes sense! /Ruth

[@oritogunfemi1041]

I just subscribed to this channel. I'm also activating the notification button. thanks

[@CurbalEN]

Welcome 🥳🥳

[@sandip_bettereveryday]

So when you are wrapping a function with CALCULATE or for that matter when you are using any measure (because all measures are by default wrapped in CALCULATE) in a Calculated Column - what we see then is "Context Transition" which is transforming the row context into filter context hence each row started showing different results. Right?

[@CurbalEN]

Yes, with calculate, the function SUM is not “blind” anymore as Calculate forces it to see the rows as filters. That is how I make sense of it. I will do a video on that on the Dax 101 series. /Ruth

[@sandip_bettereveryday]

@@CurbalEN "...is not “blind” anymore as Calculate forces it to see the rows as filters" - nicely said. Picturesque!

[@CurbalEN]

My non tech language is shining here 😂😂 /Ruth

[@saharlatifi3510]

Well explained!👍👍 Thank you so much ❤

[@CurbalEN]

Thank you :)

[@nicolehamilton8983]

Thank you for making this so easy to understand!!!

[@CurbalEN]

🥳 /Ruth

[@jonaskarlsson477]

Have little problem with filter I think i understand the new column and part of the messure but when i want to do filter i dont knot where to make it becouse when i do it i messurement, and try to use it in a table (Filter för det här visuella objektet) i get this. Aktiva = FILTER(TestTabell,TestTabell[startdate].[År] = 2019) --Or selectedvalues Uttrycket refererar till flera kolumner. Det går inte att konvertera flera kolumner till ett skalärt värde.

[@zmar9421]

Aahhh! I finally understood the difference. Thank you! :)

[@CurbalEN]

😀😀😀 Excellent! /Ruth

[@y1jadhav]

Hi Curbal, I have stuck in DAX. It will be great you help me out. I have data like below in single table Data source Amount TDS 100 ODS 200 TDS 100 UDM 200 TDS 100 ODS 200 I have to display above data in table visual but data source value in visual will be one i.e. TDS and Amount and TDS-ODS Calc Data Source ODS Amount will be subtracted from TDS value. So my output of visual will be like below. Data source Amount TDS-ODS Calc TDS 300 100 Data source ODS row is not visible in output.

[@sheilahart5989]

Thanks Ruth! Happy Friday! :-)

[@CurbalEN]

Happy Friday Sheila :) /Ruth

[@zhenweiyang6292]

This is really excellent! Great video!

[@sanierojas]

So enlightening!! Keep it up & thank you so muuchh!!

[@CurbalEN]

Yey! And thank you for watching :) /Ruth

[@nonoobott8602]

This is so brilliant and insightful. I have better understanding of the row and filter context 👍

[@CurbalEN]

Yey! /Ruth

[@aakuthotaharibabu8244]

Thank you for the great content. But please share the whole screen when executing some actions while using tools because i want to replicate the same.

[@kebincui]

Thanks Ruth👍

[@sudherkumar4292]

Wonderful... trying to get this since long time.... Great clarity given... Thanks a lot for your help.🤝🤝🤝🤝🤝🤝

[@CurbalEN]

Awesome! We will go through this in more detail in future videos :) /Ruth

[@KirillBezzubkine]

Lady is positive. Though some of her explanations are not very clear... it s fun to watch her

[@CurbalEN]

Lady will try to do better ;) /Ruth

[@kyiwinhtun]

thanks! well explained!

[@saravananoumabady1778]

Filter context and row context. Key characteristics for all beginners to understand and differentiate.

[@jdgh86]

excelent video thanks!! :)

[@CurbalEN]

Glad it helped :)

[@andrecavasotero6234]

After hearing so much about the queso cabrales I will not give up the opportunity to taste it next time I´m near Asturias.

[@CurbalEN]

😂😂😂 it is outstanding, I promise! Otherwise I will refund you ;) /Ruth

[@stefass85]

Thnak you very much!

[@alirezamogharabi8733]

Very helpful, thank you so much.

[@CurbalEN]

Awesome!! More to come on future videos :) /Ruth

[@hildeksjursen4538]

Thank You. From Norway 🤓

[@CurbalEN]

Varsågoda! /Ruth

[@marcobaquero6867]

Super clear

[@CurbalEN]

It was!? Oohhhh nice 👍 I will continue going down this rabbit hole in future videos ! /Ruth

[@oliveroshea5765]

I think Ruth could explain quantum theory to kindergarten children!

[@CurbalEN]

😂 thanks!

[@real-shepherd]

can't see your full screen, right panes are cut off

[@chengwang411]

For a while, DAX to me is like a box of chocolate: I never know what I’m gonna get...🤣🤣. If this doesn’t work, I will try that. 🙃

[@CurbalEN]

🤣🤣

[@vijaypalmanit]

what you are explaining is totally useless, you didn't tell the reason, you simply told what it is doing.anybody can do that.

[@CurbalEN]

Thanks for the feedback! /Ruth