If you get butterflies in your stomach every time you have to use CALCUATE() or FILTER() functions in your DAX then stick around, as I will try to give you some tools that will hopefully bring that anxiety to manageable levels.
This is not a short video, unfortunately. I could not cut it short because if you are not comfortable with these functions, you are probably having issues with gaps in some your understanding of several important concepts in Power BI. Therefore, I am thoroughly walking over all of the things that you should have a good grasp of before you are ready to use Calculate() and Filter().
Then we are going to go through several iteration of Calculate() and Filter() as we make our calculation more and more complex, but, again, I am taking baby steps with each iteration as I want to make sure that I am not losing you in the process.
- Power BI & DAX Making Sense of FILTER and CALCULATE ( Download)
- How to Use Calculate & Filter() in Power BI to Change Filter Context ( Download)
- DAX - Basics Of Filter Context and Calculate ( Download)
- Power BI DAX Demystified: Mastering the CALCULATE Function + All, AllExcepts, RemoveFilters & more ( Download)
- DAX CALCULATE Trick to Pass Filters from Many to One Side of Relationship ( Download)
- The Fine Difference between CALCULATE with and without FILTER Expression #dax #calculate ( Download)
- DAX CALCULATE and FILTER Functions in Power BI ( Download)
- DAX for Power BI Part 5.1 - The Calculate, Filter and CalculateTable Functions ( Download)
- Learn DAX Fundamentals in 10 Minutes | Step-by-Step Guide ( Download)
- Understanding DAX Filter Context and Incorrect Totals ( Download)
- DAX Power BI: Calculate and Filter ( Download)
- Power BI DAX Function ALL to create new Measure and to ignore the impact of a Filter ( Download)
- Making DAX Easy ( Download)
- DAX Calculate() and What are Row vs. Filter vs. Query Contexts ( Download)
- DAX REVOLUTION! Visual Calculations in Power BI ( Download)
