📊 Grouping Data

Goal: Group Sales by Color and sum up the amounts.
SUMMARIZE: Creates a new virtual table in memory.

Source: Sales Table (Raw)
Result: Summary Table
Ready...

💻 DAX Formula

-- Scenario 1: Just Grouping (Like DISTINCT)
EVALUATE Groups = SUMMARIZE( Sales, Sales[Color] )

-- Scenario 2: Grouping + Aggregation
EVALUATE Summary =
SUMMARIZE(
Sales,
Sales[Color], -- 1. Group By Column
"Total Sales", -- 2. New Col Name
SUM( Sales[Amount] ) -- 3. Expression
)
Rows Created:
-