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
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.
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 !
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.
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.❤️❤️
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.
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.
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.
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
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!)
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!
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.
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
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!❤👍😊
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 !
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!
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.
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?
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?
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.
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?
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
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.
Thanks !!!
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
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.
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 !
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.
Happy it is useful Sani!
/Ruth
Ruth is simply awesome with the way she doles out her knowledge. God bless you.
Thanks Ayobami and Happy Friday!!
/Ruth
beautifully explained. you are teacher by your nature.
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.❤️❤️
yes, excellent teacher, clear, concise, good speed, good examples, and relaxed style
Thanks Matt!
/Ruth
I love your style of teaching: fun, engaging and educating.
Thanks!
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.
Sweet dreams 😴😴!
/Ruth
Nice Job, very clear and your enthusiasm is affectious.
Coming from a business excel user's perspective - this is an easy to understand format - excellent job
We have the same background, so it might help ;)
/Ruth
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.
Glad it helped!!
/Ruth
Ooh my God 😍🙏 By the 6th minute you've already said the clarity I was looking for 😭
Thanks a lot ❣️❣️❣️
🥳🥳🥳
whenever I have difficulty understanding any DAX Function, I come here.
Thanks for Sharing your knowledge in such simple and understandable way!
Pleasure to hear :)
Ruth
rip , rippped , ripfied ....superb 16:24 ... cut to the chase....u saved hell lotta my time
Good job Ruth! Great explanation.
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.
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
@@CurbalEN Take your time to keep making great content we can wait. I'm from Uruguay!
Ah, Saludos!! :)
/Ruth
Si les pides a estos a lo mejor te lo consiguen:
www.nonnoantonio.com/quesos.html
;)
/Ruth
@@CurbalEN Muchas gracias!!
Thank you for making the DAX concepts simple
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!)
You are spoiling part 3!! ;)
/Ruth
@@CurbalEN hi
Please can I have the link where it explains this
This is known as “context transition”.
You have to know your function :) You are amazing Ruth... Thank You so much :) :)
Thank you!!
/Ruth
Wow!
Ruth you are a brilliant teacher❤️
😊
Have a great weekend!
/Ruth
Splendid explanation and humor. Awesome!
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!
You are never alone when you feel confused while DAXing, be sure of that!!
Me encanta la explicación!
Y debo admitir que la cara de trauma de "uy, ¿y ahora qué hice?" lo fue todo! :D jajaja
😂😂😂
Seguramente te llego al alma porque lo has sufrido tú también verdad?
😂😂😂 la monda!
/Ruth
fantastic exlanation.......Superb !!!!
Great explanation! You're a natural teacher!
Thanks!😊
Ruth, this stuff is gold. Please keep it up.
Will try!
Amazing video, i have been struggling with this for a while. U have made this super simple. Thanks a lot.
Wonderful to hear and enjoy your weekend!
/Ruth
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.
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
Nicely explained....simple terms. Thank you
:)
Awesome.. clear and in detailed explanation, I got answers for so many questions..
Great! Glad it helped!
/Ruth
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!❤👍😊
Thanks Joanne, you too!!
Superb !!! Very Nicely explained and really get lot on insights from watching your videos...
Good Job !!
Your videos are very clear and easy to understand, my favorite channel! Thanks for sharing knowledge! Greetings from Brazil!!!
Ohh, thanks!! 😊😊 o obrigada ;)
/Ruth
@@CurbalEN Obrigada* perfect! I love!!! :D
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.
Well explained!👍👍 Thank you so much ❤
Thank you :)
Super Teacher. Very good explanation, you made me understand concepts, which I was looking as bigginer🌹
Wonderful to hear!
Very nicely explained. Well done, as usual. Thanks so much.
Thanks Erica!! More to come on the topic :)
/Ruth
I just subscribed to this channel. I'm also activating the notification button. thanks
Welcome 🥳🥳
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 !
Weird to say this, but me too!!
I truly hope it helps beginners get a quicker start in DAX.
/Ruth
Thanks Ruth👍
This is so brilliant and insightful. I have better understanding of the row and filter context 👍
Yey!
/Ruth
Filter context and row context. Key characteristics for all beginners to understand and differentiate.
Aahhh! I finally understood the difference. Thank you! :)
😀😀😀
Excellent!
/Ruth
Lady is positive. Though some of her explanations are not very clear... it s fun to watch her
Lady will try to do better ;)
/Ruth
Thank you for making this so easy to understand!!!
🥳
/Ruth
Thanks Ruth! Happy Friday! :-)
Happy Friday Sheila :)
/Ruth
This is really excellent! Great video!
A joy to watch. Thank you.
Wonderful!
/Ruth
9:33 - CALCULATE's Filter Overrides General Filter. That s why there s only ONE number for QC product
Wonderful... trying to get this since long time.... Great clarity given...
Thanks a lot for your help.🤝🤝🤝🤝🤝🤝
Awesome! We will go through this in more detail in future videos :)
/Ruth
After hearing so much about the queso cabrales I will not give up the opportunity to taste it next time I´m near Asturias.
😂😂😂 it is outstanding, I promise! Otherwise I will refund you ;)
/Ruth
So enlightening!! Keep it up & thank you so muuchh!!
Yey! And thank you for watching :)
/Ruth
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!
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.
Thnak you very much!
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. 🙃
🤣🤣
excelent video thanks!! :)
Glad it helped :)
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?
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?
I think Ruth could explain quantum theory to kindergarten children!
😂 thanks!
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.
thanks! well explained!
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...
Not yet, but I will :)
/Ruth
@@CurbalEN ok thank you, i can wait... till tomorrow :D In my opinion the 101 serie is estremely useful, gracias
Thank You. From Norway 🤓
Varsågoda!
/Ruth
Very helpful, thank you so much.
Awesome!! More to come on future videos :)
/Ruth
Super clear
It was!? Oohhhh nice 👍
I will continue going down this rabbit hole in future videos !
/Ruth
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?
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
@@CurbalEN "...is not “blind” anymore as Calculate forces it to see the rows as filters" - nicely said. Picturesque!
My non tech language is shining here 😂😂
/Ruth
can't see your full screen, right panes are cut off
what you are explaining is totally useless, you didn't tell the reason, you simply told what it is doing.anybody can do that.
Thanks for the feedback!
/Ruth