Jan 9, 2023
Calculate is the mother function of DAX. I use Calculate almost everyday in 90% my DAX measures. With the latest update to the calculate using Or and ability use MAX and measures with aggregation as filters. The update of the semantic comes with a hidden filter. Look at the measure below
Measure :=
CALCULATE ( SUM ( Sales[SalesAmount] ), Product[Category] = “Bike” )
Above measure is simplified way to write the measure below:
Measure :=
CALCULATE (
SUM ( Sales[SalesAmount] ),
FILTER ( ALL ( Product ), Product[Category] = “Bike” )
)
Notice that the second formula use the Filter and ALL functions. To clarify that in the back end the first formula is truly evaluated to second formula by the engine.