Hidden ALL or implicit ALL in Calculate
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 […]