In the next several videos I’d like take a closer look at the more complex use of the CALCULATE function, which many believe is the most important function in DAX.
In this video, let’s start with the use of CALCULATE to calculate percentage. When using CALCULATE it’s all about making sure that correct filters are applied. With CALCULATE you can override the existing filter context with the new ones inside the function.
#PowerBI #DAX
#calculate #advanced