CALCULATE function in Power BI DAX Beginnner to Advanced | Learn all CALCULATE secrets
In this video, we explain the CALCULATE function in power bi DAX. we start by the basics of the CALCULATE function, and then we show how to use it with CALCULATE modifiers such as ALL and REMOVEFILTERS. We also show how to use it with the KEEPFILTERS function to keep the filters applied in the current filter context instead of replacing them. We also show the behavior for nesting CALCULATE functions inside each other.
Learn DAX Filter context vs Row context:
• Filter Context and Row Context in DAX...
Download Example Files:
https://tinyurl.com/yrhbxtmm
Time Stamps:
00:00 Introduction
00:19 CALCULATE function syntax and similarities to SUMIFS function
02:16 The Data model that we have
02:47 CALCULATE function basics
08:39 CALCULATE with ALL and REMOVEFILTERS
15:17 CALCULATE with ALLEXCEPT
19:01 CALCULATE with KEEPFILTERS
24:04 Nested CALCULATE functions | Nesting CALCULATE in DAX | CALCULATE inside CALCULATE
31:05 Conclusion
Sign up for our Newsletter:
https://tinyurl.com/mr33kcsd
Follow us on Social Media:
Facebook: https://tinyurl.com/254eut6z
Twitter: https://tinyurl.com/ycxkjzkk
LinkedIn: https://tinyurl.com/ycym2nee
Instagram: https://tinyurl.com/3mdpbdwa
TikTok: https://tinyurl.com/p36wae4k
Telegram: https://tinyurl.com/escuvwj9
Website: https://tinyurl.com/twtnwuv9
****My online Courses****
https://www.excelbonanza.com/courses/
#dax #powerbi #CALCULATEFUNCTION #calculate
