DAX CALCULATE Function Made Easy to Understand (just one word)
Vložit
- čas přidán 26. 06. 2024
- Get Access to the full course here 👉 www.xelplus.com/course/excel-...
The CALCULATE function is THE most powerful function in Excel Power BI and DAX. Many struggle with this function and get frustrated because it's difficult to picture what's going on. In this video I'm going to explain CALCULATE in simple terms and with a single word! I use Excel and do the explaining with a Pivot Table (Power Pivot), but the same concept applies to Power BI as well.
🔎 What You'll Learn:
- CALCULATE Basics: Uncover the fundamentals of the CALCULATE function in DAX and its core mechanics in Excel.
- Pivot Table Analogy: Understand CALCULATE through the simple analogy of a pivot table, clarifying its functionality in practical terms.
- Advanced Filtering: Explore how CALCULATE alters filter contexts to produce tailored data insights, going beyond standard pivot table capabilities.
- Real-World Examples: Follow step-by-step examples showing CALCULATE in action, from analyzing sales data to filtering innovative product sales.
- Visualizing CALCULATE: Gain clarity on CALCULATE’s process through a unique visualization method, making complex concepts easier to grasp.
00:00 CALCULATE in DAX Explained in Simple Terms
00:38 What the CALCULATE Function Does
04:01 How the CALCULATE Function Works
07:45 How to Master DAX and Data Modelling in Excel
🌍 My Online Excel Courses ► www.xelplus.com/courses/
⯆ Complete article on DAX CALCULATE: www.xelplus.com/dax-calculate...
🎬 LINKS to related videos:
- Excel Productivity for Lazy (but Smart) People: • Excel Productivity for...
- Hidden Tips in Excel Power Pivot: • 3 Secret Power Pivot T...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel #dax
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
I use calculate and had to figure it out largely by myself. Your explanation is by far the best that I have heard.
I created a data analytics sheet and was using more columns to overcome this issue
your explanation made it easier and gave me a lot of ideas
Thank you
I take off my hat and wash my hands...she's a legend, I did a number of her courses on Udemy, Power Query, Google Sheets, etc, and that was enough to get me to be the expert I am. Bravo!!!
I love how you tried to break down a complicated structure into more user-friendly structures.
Your explanation is appreciated.
I am prepping for the DA 100 exam and both classes I have taken have not given very good explanations of the CALCULATE function. They expect you to understand it from what they give you. This is by far THE BEST explanation of it! Now I get it and will be searching out more of your videos on it! THANK YOU!!
This great and easy to understand definition with practical example of how to use the function, fantastic video
Leila I've started to learn Power BI and using some DAX expressions and I could not understand very well how this function really works, but your explanation on CALCULATE function is perfect! Thanks for sharing your knowledge with us!
There is always something new in your videos to learn. Today I found some new words which I didn't notice in your course. Excellent!!
Thank you.
This was exactly what I needed for some data analysis at work - comparing several sites' time-based performance that was a percentage for each, along with the overall organization on the same pivot-chart. I left work stumped on how to do this and happened to see this video in my feed when I got home - BANG, epiphany!!! This video nailed what I was looking for, and I didn't need any other resources to get the analysis done. Perfect presentation and perfect timing for me. Thank you so much for all that you do! I wish I could give you a hug!
That's great to hear!
You know what, you did not solely teach the subject to us but had us grab it deeply by illustrating on the tables and the very logic lies behind it. Really appreciate it
Leila!!! You are an inspiration for everybody who wants to improve in life! Tnks! Hugs from Brazil!
You make complex things easy to understand. Awesome !
Estoy estudiando Power BI y no entendí qué hacía CALCULATE... viendo las tablas dinamicas ahora lo entiendo!! Eres la mejor, Leila!
"so CALCULATE function creates an invisible Pivot Table to perform a caculation and returns the results in the Pivot Table where the CALCULATE function originated from."
Thanks, this explanation worked for me!👍
Love your explanation. This will help me during the actual course when I get to that point.
I really appreciate how you presented it in a very simple manner that is easy to comprehend.
Thanks Leila for always strarting from known to unknown for beginners.
Every time i watch your videos i am mind-blown! I love learning from you. I’m taking your power query course on Udemy and it’s sooooo good!!
Absolutely very useful function in cost, planning and tax calculations avoiding to have huge resultant complex pivot tables, thanks Leila ❤ your videos from Mexico City
This is the "Best of the Best of the Best* video to learn Calculate Function.
The concepts are all there and constructively. The best video I've seen on this topic.
Perfect Leila.👌👋👋👋👋👋👋👋
Thank you!
I was looking for an easy to understand explanation on CALCULATE function. That was excellent. Impressive. Thanks a lot!
Been working with DAX for some time. That is the best visual and explanation of the Calculate function. Thank you. You’re awesome!
Awesome, thank you!
Excellent breakdown and explanation for CALCULATE, one of the best I've ever seen.
Thank you Leila! Explaining this in one word will really help me.
Leila, you are an absolute LEGEND. Thank you!
Very, very nice ! An average difficult concept was explained with simple words, and visual aids. This is a very good foundation, anyone can start building more and more nested functions, within CALCULATE. You did it in the right way, starting from basics. There are many experts our there, knowing very well many DAX things, but just few of them are able to explain and make other people understand. You are one of them, dear Leila. I also love this short inserts with Stewie Griffin, really funny ! :-D.
Thank you! Appreciate that.
Great introduction to the CALCULATE function. Thank you so much!
Finally, I now understood. Thanks, Leila!
Leila makes is sooooo easy to understand! Thank you so much! Respect!!
Wonderfully explained as always. Thanks Leila🙏
I love this and all videos of yours! This is why I am subbed!!!
This just may be the very best, most concise, and easy-to-understand explanation of the Calculation function that I think I've heard, and I've heard a ton! Great job! Thank you.
Wow, thank you!
Thank you 🙏🏽😃! Perfect explanation. Now I understand the CALCULATE function.
Awesome, your teaching and example is at next level. I have enrolled for Power BI course from other tutor but eagerly waiting for your course. Thanks Again.
Thank you for this wonderful video. Finally, i get to understand CALCULATE function....
Beautifully explained. This video has so much value. Thank you for making this. It’s helping me review for my online course.
Now I could understand the Calculate function much better after your explanation! Thank you very much, Leila!!
Glad it was helpful!
Leila, thank you so much. I've been learning a lot with your videos lately. Great job!.
Glad to hear that, Gustavo!
Teaching skills 10/10
I was trying to get my head round this CALCULATE function, but you have explained well and am beginning to get the gist of it.
this is the only time I have finally understood the CALCULATE function. Thank you !!
You're most welcome, Giovanni!
Brilliant explanation. Thank you!
Awesome tips! This is such a nice function!
It really is!
the first video i watched for power bi. Great one!
love it. nice one to get help in daily routine work. Much appreciated
For me ... a peek inside a world that someday I hope to fully understand ... and utilize. The presentation is perfect (no surprise).
Many thanks for your support!
Simple, Precise and clear. Keep it up
Great introduction to Calculate. Really good approach to show a simple visual example. Kudos
I love the simple explanation!
It was Awesome, thank you so much for sharing. I've never heard anything like that about CALCULATE. I think that now, I understand it better.
Thank you for an easy to follow explanation.
i read and saw a lot of stuff but this video is the only thing that made me understand the function
Glad it was helpful!
Thanks leila for every thing but we are waiting a Dax series from along time..waiting ur announcement 😊
This was a great explanation. Easier to use this once you understand what it is actually doing and how its doing it. Thank you.
Great explenation, thank you!
Very useful. Thank you!
Thank you so much , you explain things very eazy , thank you again
Nice Explanation.
Thankyou for sharing.
Leila Gharani special thanks for the video and explaining the full fledged functioning of calculate function.
Very easy to understand - much more pedagogical than SQLBI guys. Thank you!
Great explanation of CALCULATE.... 👍
After watching 50 vdos this one is best n so easy
Very neat explanation of CALCULATE....❤
Excellent Explanation!
Thanks 😊 for easy explain.
I was finding it tough to understand this concept but thanks to your video, it was impressively explained
Absolutely amazing explanation of CALCULATE with Pivot table example
Glad you liked it!
Thanks! So very well explained. The only problem in the practical world is that very few Managements are prepared to go for the Office 365 yet. Particularly Local Government Councils!!
Great explanation, thanks !
you have a unique way to make all your tutorials incomprehensible even the ones that are supposed to be "made easy".
great explanation of the Filter Context (local pivot filters overriding the CALCULATE filter (which in Power BI with no filter tables, the slicers override the Calculate function).
and wonderful demo of whats really happening under the hood of CALCULATES intrinsic filters. I did an excel/powerPivot/Dax course it was good, but I will sign up for yours as well having experienced how well you articulate and video. Will be fun to learn more with insightful perspectives.
That's great to hear. See you on the inside!
It's an Art to explain complicated things in a simpler way. And you naturally have this ability to perceive how people could recive. Its really benefiting for most of us. Looking forward..
Thank you for the kind feedback.
That was super useful, thank you.
Excellent way to explain complicated function.
Great explanation!!
Great stuff - this totally explained it one go - 3 mins in and I've already solved my problem. Thank you.
Glad it was helpful!
Great explanation 🤗 thank you Leila you're my best
Absolutely brlliant, thank you!
nice explication, thank you.
Thanks leila. Very well explained !
Leila, Great explanation as usual ! It definitely makes sense after you provided the background and the examples.
Happy to hear that!
That left --> right thing was great way to explain, Liela! I knew the filter context but dint quite visualize the way you did. Thanks.
Glad it was helpful, John!
Thank you, now it is so much easier to understand and remember :)
Like each time very clear and comprehensive explanations 🙂
Glad you think so!
Excellent! Thank you so much for posting such knowledge. Brilliant explanation in whole of you-tube
It is very usefull. Thank you.
Thanks, Leila!
great explanation!
It was wonderful - Thank you Leila
Great video. Easy to understand and not too long.
Glad you enjoyed it!
So it basically control your data universe based on filters you pass and then apply the expression. Very well explained Leila. Success!!
Thank you!
You are absolutely awesome ! Thank you
I swear you are a good teacher 👍
Whoooaaahhh, great explanation!!!
Genial explicación, saludos Leila y gracias.
Thank you for this explanation. Really easy to understand, and helpfull to create an new measure...
Great to hear!
Great Help and im thinking now enrolling to your courses i think i will learn more from your course...