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

Подписаться 134 тыс.

Просмотров 51 тыс.

50% 1

Are you new to DAX and want to learn what those things called filter context and row context are? I will attempt to do just that in today's video. Let me know how I did in the comments :) #dax #powerbi #daxfridays #curbal
Happy friday!
DAX 101 playlist: • DAX 101
Vertipaq playlist here: • What is Vertipaq and h...
DAX funcitons playlist here:
• DAX Fridays! #1: How t...
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB

Опубликовано:

5 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 129

@Freemachains 3 года назад

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 !

@oritogunfemi1041 2 года назад

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 2 года назад

Thanks !!!

@SaniGarba 4 года назад

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 4 года назад

Happy it is useful Sani! /Ruth

@khalidrasheed7724 Год назад

beautifully explained. you are teacher by your nature.

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

@Shib_ghosh 4 года назад

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.❤️❤️

@therealcomment5622 3 года назад

Splendid explanation and humor. Awesome!

@ayobamiologun9184 5 лет назад

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

@CurbalEN 5 лет назад

Thanks Ayobami and Happy Friday!! /Ruth

@matthewclarke2899 4 года назад

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

@CurbalEN 4 года назад

Thanks Matt! /Ruth

@rpv1494 2 года назад

Nice Job, very clear and your enthusiasm is affectious.

@cadurgeshagrawal 3 года назад

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

@ashaoluayanfe7474 Год назад

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

@CurbalEN Год назад

Thanks!

@tak0331 Год назад

Good job Ruth! Great explanation.

@mePrafull Год назад

Thank you for making the DAX concepts simple

@deedeec102 3 года назад

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 3 года назад

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

@Prasoon.Chauhan 4 года назад

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 4 года назад

Sweet dreams 😴😴! /Ruth

@joanneosborne2428 4 года назад

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 4 года назад

Thanks Joanne, you too!!

@rakahs5 4 года назад

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

@CurbalEN 4 года назад

Wonderful to hear and enjoy your weekend! /Ruth

@zhenweiyang6292 4 года назад

This is really excellent! Great video!

@EricaDyson 5 лет назад

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

@CurbalEN 5 лет назад

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

@mangaldeep9544 2 года назад

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

@techienomadiso8970 2 года назад

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

@CurbalEN 2 года назад

🥳🥳🥳

@mangaldeep9544 2 года назад

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

@TheAlgebraTeacherPOWERStoBI 4 года назад

Great explanation! You're a natural teacher!

@CurbalEN 4 года назад

Thanks!😊

@hasnainhaider8191 3 года назад

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 3 года назад

Glad it helped!! /Ruth

@TroyLambert 4 года назад

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

@CurbalEN 4 года назад

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

@ssma1368 4 года назад

Wow! Ruth you are a brilliant teacher❤️

@CurbalEN 4 года назад

😊 Have a great weekend! /Ruth

@sudherkumar4292 5 лет назад

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

@CurbalEN 5 лет назад

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

@osamaasif9601 3 года назад

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

@CurbalEN 3 года назад

Will try!

@zvlspm9421 4 года назад

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

@CurbalEN 4 года назад

😀😀😀 Excellent! /Ruth

@vakfunnyfactstelugu9531 4 года назад

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

@CurbalEN 4 года назад

Great! Glad it helped! /Ruth

@jasonwoodward5501 4 года назад

A joy to watch. Thank you.

@CurbalEN 4 года назад

Wonderful! /Ruth

@michelcesar85 5 лет назад

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

@CurbalEN 5 лет назад

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

@michelcesar85 5 лет назад

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

@poojasahasrabhojanee971 4 года назад

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

@CurbalEN 4 года назад

Thank you!! /Ruth

@sanierojas 4 года назад

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

@CurbalEN 4 года назад

Yey! And thank you for watching :) /Ruth

@Maurici0GP 4 года назад

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 4 года назад

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

@junaidbagwan5523 4 года назад

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

@CurbalEN 4 года назад

Pleasure to hear :) Ruth

@nicolehamilton8983 4 года назад

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

@CurbalEN 4 года назад

🥳 /Ruth

@saharlatifi3510 2 года назад

Well explained!👍👍 Thank you so much ❤

@CurbalEN 2 года назад

Thank you :)

@philipmathew6542 Год назад

Nicely explained....simple terms. Thank you

@CurbalEN Год назад

@sheilahart5989 5 лет назад

Thanks Ruth! Happy Friday! :-)

@CurbalEN 5 лет назад

Happy Friday Sheila :) /Ruth

@Victor-ol1lo 5 лет назад

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 5 лет назад

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

@fguihen 4 года назад

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?

@kyiwinhtun 3 года назад

thanks! well explained!

@kebincui 3 года назад

Thanks Ruth👍

@claurecoba11 5 лет назад

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 5 лет назад

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 5 лет назад

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

@CurbalEN 5 лет назад

Ah, Saludos!! :) /Ruth

@CurbalEN 5 лет назад

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

@claurecoba11 5 лет назад

@@CurbalEN Muchas gracias!!

@alirezamogharabi8733 5 лет назад

Very helpful, thank you so much.

@CurbalEN 5 лет назад

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

@nonoobott8602 4 года назад

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

@CurbalEN 4 года назад

Yey! /Ruth

@oritogunfemi1041 2 года назад

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

@CurbalEN 2 года назад

Welcome 🥳🥳

@Truth-N-Lies 3 года назад

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

@CurbalEN 3 года назад

Wonderful to hear!

@alanhernandez7201 3 года назад

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!

@jdgh86 3 года назад

excelent video thanks!! :)

@CurbalEN 3 года назад

Glad it helped :)

@stefass85 3 года назад

Thnak you very much!

@rick_. 5 лет назад

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 5 лет назад

You are spoiling part 3!! ;) /Ruth

@getusama 4 года назад

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

@jianhongsong6140 2 года назад

This is known as “context transition”.

@emmadkareem5247 5 лет назад

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 5 лет назад

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

@hildeksjursen4538 5 лет назад

Thank You. From Norway 🤓

@CurbalEN 5 лет назад

Varsågoda! /Ruth

@andrecavasotero6234 5 лет назад

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 5 лет назад

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

@marcobaquero6867 5 лет назад

Super clear

@CurbalEN 5 лет назад

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

@KirillBezzubkine 4 года назад

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

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

@trondlk 3 года назад

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?

@jonaskarlsson477 2 года назад

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.

@walterben3111 4 года назад

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 4 года назад

Not yet, but I will :) /Ruth

@walterben3111 4 года назад

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

@saravananoumabady1778 2 года назад

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

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

@sandip_bettereveryday 5 лет назад

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 5 лет назад

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 5 лет назад

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

@CurbalEN 5 лет назад

My non tech language is shining here 😂😂 /Ruth

@KirillBezzubkine 4 года назад

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

@CurbalEN 4 года назад

Lady will try to do better ;) /Ruth