⚙️ Power BI DAX: CALCULATE vs CALCULATETABLE

Both are powerful DAX functions that change filter context — but they return different types:

---

🧮 CALCULATE() → Returns a Value

Used for creating measures or KPIs.

📌 Example:

dax

Total Sales East = CALCULATE(SUM(Sales[Amount]), Sales[Region] = "East")

✅ Returns a scalar result (e.g., total amount for East region)

---

📊 CALCULATETABLE() → Returns a Table

Used when you need a filtered table.

📌 Example:

dax

EastSalesTable = CALCULATETABLE(Sales, Sales[Region] = "East")

✅ Useful with iterators like SUMX, COUNTROWS, AVERAGEX

---

⚖️ Quick Comparison

Feature	CALCULATE() ⚙️	CALCULATETABLE() 📊
Returns	Single value (scalar)	Table
Used for	Measures / KPIs	Iteration / Filters
Works with	SUM, COUNT, MAX	SUMX, COUNTROWS

---

🧠 Tip

Use CALCULATE for totals with filters, and CALCULATETABLE for filtered rows you want to iterate over.