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

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 funcitons playlist here:

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

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

[oritogunfemi]

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.

[mohammadazadi]

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

[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 ! <3

[ayobamiologun]

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

[matthewclarke]

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

[ashaoluayanfe]

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

[khalidrasheed]

beautifully explained. you are teacher by your nature.

[rpv]

Nice Job, very clear and your enthusiasm is affectious.

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

[claurecoba]

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.

[techienomadiso]

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

Thanks a lot ❣️❣️❣️

[hasnainhaider]

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.

[TroyLambert]

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

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

[alanhernandez]

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!

[therealcomment]

Splendid explanation and humor. Awesome!

[mePrafull]

Thank you for making the DAX concepts simple

[osamaasif]

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

[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?