Hidden ALL or implicit ALL in Calculate

Hidden ALL or implicit ALL in Calculate

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.

Recent Posts

Recent Posts

Consult with us today.

Consult with us today.