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

Harnessing Real-Time Insights with Data Activator in Microsoft Fabric
Feb 19, 2024

Democratizing Data with Fabric: Everyone, a Data Analyst
Jan 24, 2024

Fabric's AI Advantage: Unveiling Hidden Patterns in the Data Tapestry
Dec 13, 2023