Power BI DAX Demystified: Mastering the CALCULATE Function + All, AllExcepts, RemoveFilters & more

Easy to understand explanation to master the most powerful and the most important DAX CALCULATE function with simple examples.

If you have attempted to learn how to use Calculate, but still feeling confused…
Don't worry.. You are not alone.
This Calculate video tutorial will help you to understand the key concepts in simple english.

I will explain the two most important concept that you need to grasp in order to build a strong foundation that will help to boost your future confidence in using CALCULATE and writing your own CALCULATE function from scratch, instead of blindly copying and pasting from Google.

I will also explain a fundamental concept of FILTER CONTEXT for those of you who are still relatively new to Power BI, as this is an important concept that you will need understand, in order to avoid unexpected surprises in the future.

There will be plenty of examples of CALCULATE in actions... starting from the very simple use of CALCULATE without any filter criteria... and then building on by adding 1 criteria, multiple criteria, as well as using various combinations of other DAX formulas such as: OR criteria, RemoveFilters, All and AllExcept.

I will also explain the short way vs the long way of writing DAX filter criteria, which will give you the same outcome.

My sincere hope is that by the end of this video, you will be more familiar and more confident in using the CALCULATE function in Power BI.

Cheers,
Isabella Susilowati
#LighthouseAnalytix
#PowerBITutorialForBeginners

P.S. Next week I will post video on how we can use the CALCULATE function in Power BI to build a P&L report. More specifically how we use this function to report This Year P&L, Last Year P&L as well as YOY P&L movement.
Stay tune... and please do subscribe so that you don't miss out !!!

Timelines:
00:00 Introduction
01:47 Similarity with SUMIFS
03:03 Criteria in Calculate will override Filter Context
03:18 The meaning of FILTER CONTEXT
06:28 The meaning of OVERRIDE
06:41 Simple examples of Calculate
08:01 More complex examples of Calculate
10:13 Calculate with OR
11:08 Calculate with split lines
11:44 Calculate with RemoveFilters
13:04 Calculate with ALL
13:55 Calculate with AllExcept
15:14 Recap
15:35 The SHORT way vs the LONG way

LA48

[heeby]

I've watched so many explanations of CALCULATE by a lot of the big time Youtubers and this video explained the concept FAR better than they did.

[cedartree]

Seriously the best explanation of this topic I've found anywhere-- including paid courses. I can say, finally, I get it. Thanks so much Isabella!

[mohamedsalih]

Think someone is benefited out of this video even after 2 years of posting! I watched many videos to understand filter context and finally I arrived at the right place. Thanks a lot

[vineet]

thanks. The best explanation. Fully understand CALCULATE, ALL, ALLEXCEPT, FILTER and REMOVEFILTER functions now.

[precioussimplemessagesofli]

I could understand the calculate function better since its crystal clear explanation but I couldn't understand why this kind of excellent channel only have less than 1k subscribers. Guys please support it and I will recommend it to all my friends.

[ralphs]

This is by far the most comprehensible and beginner-friendly tutorial I found online. Thank you!

[jagans]

Wonderful video mam, I wish you live 200+ years. Thank you. God bless!! ❤

[snipelite]

Well done, Isabella 👍😁
Using a comparison of filtered and measures tables, side by side, was the best visual explainer that I've seen yet!
I've seen a number of CALCULATE vids from different content creators, but this was definitely the most accessible and visually satisfying and enlightening.
Many Thanks

[smallflyDE]

Most beginner friendly video for CALCULATE. Thanks! Also very nice that you explain ALL function in this context :-)

[osoriomatucurane]

Sensacional tutorial on calculate superpowerful function and the filter context. Awesome break down and visual set up, turning the concept just easily digestable as taking breakfast in the morning. Bravo, Isabella, keep it up.
Another way of dismytifying the concept is revealing what happens beyond the scrnes or under the hood, with the filter propagation from through the model relationship from tue dimension(lookup) tables, before the aggregation ou summarization of the filtered records takes places ou performed over the fact table).
I really like the similarities with the sumifs() function and the superiority of calculate () over the sumifs() as given by its versatility, just making it all in one.

[sjpark]

I like your approach of starting with the DAX formular construct. Got the thoery right before the actual examples.

[Adaaaaaaa.]

Thanks a lot for breaking it down this way!

[henryfung]

This helps me a lot. That is the best explanation across the youtube I watched. Thank you so much.

[ankitpant]

This was so easy to understand. Thank you!

[NaraMeerammaTrust]

very good presentation including your explanation. I love this video.

[schtefel]

seriously, this explanation is sooo good! 😃

[ajayraj-xgwj]

Very useful, clear and precise.. Would like to learn about the iteration functions too.. It would be very much helpful

[johnknowledge]

Great Presentation. I have subscribed.

[softwine]

BRAVO !!! The best video to understand calculate and filter context.
Thank you !
I have one question, all is the same as removefilters, so in order to override any filter we can simply use all(), could we use the same things with removefilters ??

[CikYlang]

Hai isabella, tq for your video.. just want to ask, do you have any video on finance lease calculation example in power bi