CALCULATE: The King of DAX
AS
Aman Saurav
20 min read
#dax
CALCULATE changes the context in which a measure is evaluated.
Total Red Sales =
CALCULATE(
SUM(Sales[Amount]),
Product[Color] = 'Red'
)
This is the only function that can transform row context into filter context.