Goal: Calculate sales for "High Value" products (Price > $50).
FILTER iterates row-by-row to build a new virtual table.
Ready...
💻 DAX Formula
-- Scenario: Calculate Sales for Expensive Items
MEASURE High Val Sales =
CALCULATE (
SUM ( Sales[Amount] ),
FILTER (
Sales, // 1. Input Table
Sales[Price] > 50 // 2. Condition (Row by Row)
)
)