Tap to unmute

DAX CALCULATE Function Made Easy to Understand (just one word)

  Рет қаралды 336,990

Leila Gharani

Leila Gharani

Күн бұрын

Пікірлер: 339
@LeilaGharani
@LeilaGharani 11 ай бұрын
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
@ayandapeter1681
@ayandapeter1681 2 жыл бұрын
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!!!
@richardhay645
@richardhay645 3 жыл бұрын
I use calculate and had to figure it out largely by myself. Your explanation is by far the best that I have heard.
@susanknoll8721
@susanknoll8721 2 жыл бұрын
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!!
@hulem98
@hulem98 3 жыл бұрын
I love how you tried to break down a complicated structure into more user-friendly structures. Your explanation is appreciated.
@aTallCool1
@aTallCool1 3 жыл бұрын
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!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
That's great to hear!
@andrea_rico
@andrea_rico 8 ай бұрын
Estoy estudiando Power BI y no entendí qué hacía CALCULATE... viendo las tablas dinamicas ahora lo entiendo!! Eres la mejor, Leila!
@adrianodossantosfernandes1236
@adrianodossantosfernandes1236 Жыл бұрын
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!
@mosherif47
@mosherif47 6 ай бұрын
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
@stickercode
@stickercode 2 жыл бұрын
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
@Jb-3333
@Jb-3333 3 ай бұрын
I cant say how much this video helped me. ❤
@LeilaGharani
@LeilaGharani 3 ай бұрын
I'm so glad!
@ahmedtareq5342
@ahmedtareq5342 3 жыл бұрын
This great and easy to understand definition with practical example of how to use the function, fantastic video
@pixelmasque
@pixelmasque Жыл бұрын
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.
@LeilaGharani
@LeilaGharani Жыл бұрын
That's great to hear. See you on the inside!
@amber5247
@amber5247 2 жыл бұрын
Been working with DAX for some time. That is the best visual and explanation of the Calculate function. Thank you. You’re awesome!
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Awesome, thank you!
@romulusmilea2747
@romulusmilea2747 3 жыл бұрын
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.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Thank you! Appreciate that.
@Muuip
@Muuip 3 жыл бұрын
"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!👍
@rodolfovieira899
@rodolfovieira899 3 жыл бұрын
Leila!!! You are an inspiration for everybody who wants to improve in life! Tnks! Hugs from Brazil!
@Faadiz
@Faadiz 3 жыл бұрын
This is the "Best of the Best of the Best* video to learn Calculate Function.
@DemetriPanici
@DemetriPanici 3 жыл бұрын
Awesome tips! This is such a nice function!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
It really is!
@ChrisSmithFW
@ChrisSmithFW 2 жыл бұрын
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.
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Wow, thank you!
@Giovanni-vx8xl
@Giovanni-vx8xl 3 жыл бұрын
this is the only time I have finally understood the CALCULATE function. Thank you !!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
You're most welcome, Giovanni!
@chh8860
@chh8860 3 жыл бұрын
For me ... a peek inside a world that someday I hope to fully understand ... and utilize. The presentation is perfect (no surprise).
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Many thanks for your support!
@popcornchicken9302
@popcornchicken9302 8 ай бұрын
Thank you Leila! Explaining this in one word will really help me.
@GurayVural-nz1lk
@GurayVural-nz1lk Жыл бұрын
I was looking for an easy to understand explanation on CALCULATE function. That was excellent. Impressive. Thanks a lot!
@cassioalexan
@cassioalexan 3 жыл бұрын
Now I could understand the Calculate function much better after your explanation! Thank you very much, Leila!!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Glad it was helpful!
@pedroemanuelrebelo2182
@pedroemanuelrebelo2182 3 жыл бұрын
The concepts are all there and constructively. The best video I've seen on this topic. Perfect Leila.👌👋👋👋👋👋👋👋
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Thank you!
@nitingoyal1979
@nitingoyal1979 3 жыл бұрын
I love this and all videos of yours! This is why I am subbed!!!
@veemaps9819
@veemaps9819 Жыл бұрын
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.
@destinydie
@destinydie 7 ай бұрын
I was finding it tough to understand this concept but thanks to your video, it was impressively explained
@tahirhanif9669
@tahirhanif9669 Жыл бұрын
Leila, you are an absolute LEGEND. Thank you!
@sivasubramaniamappadurai1944
@sivasubramaniamappadurai1944 3 жыл бұрын
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..
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Thank you for the kind feedback.
@luckymike4590
@luckymike4590 2 жыл бұрын
you have a unique way to make all your tutorials incomprehensible even the ones that are supposed to be "made easy".
@lwinsoemar7405
@lwinsoemar7405 3 жыл бұрын
You make complex things easy to understand. Awesome !
@Tommietusindbuks
@Tommietusindbuks Жыл бұрын
Very easy to understand - much more pedagogical than SQLBI guys. Thank you!
@Turnivor
@Turnivor 3 ай бұрын
Thanks
@hossein3945
@hossein3945 2 жыл бұрын
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.
@kostaskolotouros4345
@kostaskolotouros4345 2 жыл бұрын
Great introduction to the CALCULATE function. Thank you so much!
@saqibhussain9555
@saqibhussain9555 8 ай бұрын
Leila Gharani special thanks for the video and explaining the full fledged functioning of calculate function.
@balendranrajanathan6808
@balendranrajanathan6808 3 жыл бұрын
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!!
@taniadogra4255
@taniadogra4255 Жыл бұрын
the first video i watched for power bi. Great one!
@nameismike1801
@nameismike1801 3 жыл бұрын
I am in your debt as your video cleared lots of unclear thoughts. It is a simple yet powerful explanation. Thank you!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
I’m glad to hear that!
@Artvives
@Artvives Жыл бұрын
Your explanation method is so awesome that it's easy to understand many complicated things in a short way. Please I want more video about excel. Thank you so much to make video like this❤❤❤
@mohammadtawhidulislam4459
@mohammadtawhidulislam4459 3 жыл бұрын
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.
@optimistprime709
@optimistprime709 3 жыл бұрын
I really appreciate how you presented it in a very simple manner that is easy to comprehend.
@leandratel2466
@leandratel2466 Жыл бұрын
Thank you 🙏🏽😃! Perfect explanation. Now I understand the CALCULATE function.
@HassanRaza-pe5rh
@HassanRaza-pe5rh 2 жыл бұрын
Leila makes is sooooo easy to understand! Thank you so much! Respect!!
@Buhassan5656
@Buhassan5656 3 жыл бұрын
Thank you for this wonderful video. Finally, i get to understand CALCULATE function....
@gusmoraes
@gusmoraes 3 жыл бұрын
Leila, thank you so much. I've been learning a lot with your videos lately. Great job!.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Glad to hear that, Gustavo!
@joseantonioperez8273
@joseantonioperez8273 3 жыл бұрын
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
@eben01
@eben01 11 ай бұрын
Great stuff - this totally explained it one go - 3 mins in and I've already solved my problem. Thank you.
@LeilaGharani
@LeilaGharani 11 ай бұрын
Glad it was helpful!
@johnabram4159
@johnabram4159 3 жыл бұрын
That left --> right thing was great way to explain, Liela! I knew the filter context but dint quite visualize the way you did. Thanks.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Glad it was helpful, John!
@thatwasavailable
@thatwasavailable Ай бұрын
best explanation even better than the official power bi documentation
@Juan-rk8wk
@Juan-rk8wk Жыл бұрын
Beautifully explained. This video has so much value. Thank you for making this. It’s helping me review for my online course.
@kacornish1
@kacornish1 2 жыл бұрын
Excellent breakdown and explanation for CALCULATE, one of the best I've ever seen.
@borisgrushin868
@borisgrushin868 3 жыл бұрын
Didn't understand why you'd use this function vs just pivot until I saw the filtered data next to unfiltered data and then yes, mind blown. Used to have to do several pivots and do lookups to get that. Thanks!
@Afrikan221
@Afrikan221 3 жыл бұрын
I'd say the same. I use to put many pivots and use getpivotdata :-)
@nithiniloveu
@nithiniloveu 2 жыл бұрын
Wow what an approach to get into people's head on how Dax works. This is pretty much everything made it so easy to understand nd Dax is such a hard concept to grasp. Thank a lot for this . Now just matter of learning the functions
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Thank you for the kind feedback!
@pr0vider
@pr0vider 3 жыл бұрын
So it basically control your data universe based on filters you pass and then apply the expression. Very well explained Leila. Success!!
@vida1719
@vida1719 3 жыл бұрын
Absolutely amazing explanation of CALCULATE with Pivot table example
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Glad you liked it!
@vicvic553
@vicvic553 2 жыл бұрын
Thank you, now it is so much easier to understand and remember :)
@davidk919
@davidk919 3 жыл бұрын
Simple, Precise and clear. Keep it up
@JahfaliA
@JahfaliA 3 жыл бұрын
I swear you are a good teacher 👍
@Feylplp
@Feylplp 2 жыл бұрын
This was a great explanation. Easier to use this once you understand what it is actually doing and how its doing it. Thank you.
@zanodeloza2636
@zanodeloza2636 Жыл бұрын
Finally, I now understood. Thanks, Leila!
@xyclos
@xyclos Жыл бұрын
Wonderfully explained as always. Thanks Leila🙏
@navisalomi
@navisalomi 3 жыл бұрын
Thanks Leila for always strarting from known to unknown for beginners.
@ronakshah9561
@ronakshah9561 Жыл бұрын
Excellent! Thank you so much for posting such knowledge. Brilliant explanation in whole of you-tube
@nssdesigns
@nssdesigns Жыл бұрын
Just purchased the Power BI Fast Track Course and was looking for more DAX features. Must say I love the course although DAX is challenging atm
@Jay-oj5cd
@Jay-oj5cd 2 жыл бұрын
i read and saw a lot of stuff but this video is the only thing that made me understand the function
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Glad it was helpful!
@MrStivi1981
@MrStivi1981 Жыл бұрын
I love the simple explanation!
@Al-Ahdal
@Al-Ahdal 3 жыл бұрын
Great explanation of CALCULATE.... 👍
@umangdbz
@umangdbz 3 жыл бұрын
This is the fastest I have ever clicked on a video upload!
@msachinkumar9886
@msachinkumar9886 3 жыл бұрын
After watching 50 vdos this one is best n so easy
@RobertWalthery1975
@RobertWalthery1975 Жыл бұрын
Like each time very clear and comprehensive explanations 🙂
@LeilaGharani
@LeilaGharani Жыл бұрын
Glad you think so!
@mahadevshah3099
@mahadevshah3099 3 жыл бұрын
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.
@ghazisabri1377
@ghazisabri1377 2 жыл бұрын
Thank you so much , you explain things very eazy , thank you again
@henrylokrit232
@henrylokrit232 2 жыл бұрын
Well Explained 👍🏿. Thank you so much 🙏🏿. Now I have a clearer picture on what's going on at the background of CALCULATE( ). 👊🏿👊🏿
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Glad it was helpful!
@agnespitka3703
@agnespitka3703 Жыл бұрын
Great video. Easy to understand and not too long.
@LeilaGharani
@LeilaGharani Жыл бұрын
Glad you enjoyed it!
@Assif.Noilousse
@Assif.Noilousse 3 жыл бұрын
thank you very much, now I've understood what the Calculate function is and how to use it.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Great to hear!
@mrmizat4546
@mrmizat4546 Жыл бұрын
Wish i could give a 100 thumbs up at a time.. Greatly explained
@riccardoczech6195
@riccardoczech6195 2 жыл бұрын
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!!
@RossMaynardProcessExcellence
@RossMaynardProcessExcellence 2 жыл бұрын
You made it sound easy - after I hadn't understood any of the written explanations on other websites.
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Glad it was helpful!
@newmasuzzo
@newmasuzzo 2 жыл бұрын
Leila, Great explanation as usual ! It definitely makes sense after you provided the background and the examples.
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Happy to hear that!
@tifouraamina1761
@tifouraamina1761 3 жыл бұрын
Great explanation 🤗 thank you Leila you're my best
@wayneedmondson1065
@wayneedmondson1065 3 жыл бұрын
Hi Leila. Great tutorial! A perfect way to visualize how calculate modifies the existing filter context of the pivot table or visual (PBI). Thanks for this insight. Really helps when trying to understand how DAX works. Thumbs up!!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Thanks, Wayne! It's not an easy function to grasp but once it clicks, so powerful.
@wayneedmondson1065
@wayneedmondson1065 3 жыл бұрын
@@LeilaGharani Agreed! Must practice, practice, practice :))
@rollysalenga3634
@rollysalenga3634 2 жыл бұрын
Great Help and im thinking now enrolling to your courses i think i will learn more from your course...
@Tommie_Rogers
@Tommie_Rogers 3 жыл бұрын
Love your explanation. This will help me during the actual course when I get to that point.
@MsLegendlime
@MsLegendlime 3 жыл бұрын
Omg! This was right on time. I was trying to do this very thing this morning.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Perfect!
@MsLegendlime
@MsLegendlime 3 жыл бұрын
Are there any plans to do any videos on Power BI Paginated Reports?
@carolinaleon5998
@carolinaleon5998 3 жыл бұрын
Very helpful video ! Also it was funny that you included Brian and Stewie from Family Guy at 0:35 XD
@sqlbasicrd3872
@sqlbasicrd3872 2 жыл бұрын
you are rock to explain in difficult concept with easy method .very nice.
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Glad you liked it.
@kaygeebee
@kaygeebee 3 жыл бұрын
CALCULATE = pivotable within pivotable. Got it!
@marshallhosel1247
@marshallhosel1247 3 жыл бұрын
Thank you for an easy to follow explanation.
@krishnakishorepeddisetti4387
@krishnakishorepeddisetti4387 3 жыл бұрын
I am a big fan of your videos leila... The way you make things simple is really admirable.. Plz make more videos on dax and also on M language.. To make it more simple to learn I have also purchased your trainings in udemy.. They are amazing
@pixelmasque
@pixelmasque Жыл бұрын
true M is a big area of mystery with little learning material in depth and useful. there is one 3 part course on Udemy I bought it but havent used it yet.
@chelonew77
@chelonew77 2 жыл бұрын
Nice explanation, love it. I understood clearly. I'll sign up to your course soon.
@LeilaGharani
@LeilaGharani 2 жыл бұрын
👍
@UU-ry6gt
@UU-ry6gt 2 жыл бұрын
And the teacher of the year iiiiiiiis..... Leila :)
@eduardomunoz2764
@eduardomunoz2764 2 жыл бұрын
Genial explicación, saludos Leila y gracias.
@avechristusrex04
@avechristusrex04 3 ай бұрын
thank you! finally understood the function
@hansklein3649
@hansklein3649 3 жыл бұрын
I recently watched a great video from chandoo channel, which was called advanced excel formulas are like lego. When i now got through calculate function combined with pivot table and so on, I can only add: engineer your brain!
@chrism9037
@chrism9037 3 жыл бұрын
Very good explanation, thanks Leila!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Thanks, Chris!
@martinargimon730
@martinargimon730 3 жыл бұрын
Thanks leila. Very well explained !
@larslindberg745
@larslindberg745 2 жыл бұрын
Great introduction to Calculate. Really good approach to show a simple visual example. Kudos
Tuna 🍣 ​⁠@patrickzeinali ​⁠@ChefRush
00:48
albert_cancook
Рет қаралды 148 МЛН
Quando eu quero Sushi (sem desperdiçar) 🍣
00:26
Los Wagners
Рет қаралды 15 МЛН
The evil clown plays a prank on the angel
00:39
超人夫妇
Рет қаралды 53 МЛН
We Attempted The Impossible 😱
00:54
Topper Guild
Рет қаралды 56 МЛН
Pivot Table Mistakes You're Probably Making (And How to Fix Them!)
9:45
When Should You Use the Hash Sign in Excel Formulas?
10:53
Leila Gharani
Рет қаралды 1,1 МЛН
Power BI: How to Write any DAX Measure In Just 3 Easy Steps 👣
24:17
Avi Singh - PowerBIPro
Рет қаралды 39 М.
7 Advanced PivotTable Techniques That Feel Like Cheating
16:07
MyOnlineTrainingHub
Рет қаралды 102 М.
📊 How to use Power BI DAX - Tutorial
37:28
Kevin Stratvert
Рет қаралды 1,2 МЛН
Don't make these CALCULATE Function Mistakes! ⚠️
10:09
What is DAX?
17:48
Access Analytic
Рет қаралды 42 М.
The Excel Tool That Does What PivotTables Can’t (File Included)
13:59
MyOnlineTrainingHub
Рет қаралды 218 М.
Tuna 🍣 ​⁠@patrickzeinali ​⁠@ChefRush
00:48
albert_cancook
Рет қаралды 148 МЛН