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