Pbi Dax Functions — Free Power Bi Tutorial
Learn Pbi Dax Functions in Power Bi with a free, beginner-friendly tutorial, examples and practice for Indian students on Syllab.in.
TL;DR: Learn Pbi Dax Functions in Power Bi with a free, beginner-friendly tutorial, examples and practice for Indian students on Syllab.in.
Written & reviewed by the Syllab.in Academic Team (CBSE/NCERT subject experts) · Updated
Pbi Dax Functions in Power Bi
SUM() aggregates a column: SUM(Sales[Amount]) = total of all amounts. CALCULATE() applies filters to a measure: CALCULATE(SUM(Sales[Amount]), Region = "North") = sum only for North region, overriding dashboard filters. FILTER() creates a dynamic table filtered by condition: FILTER(ALL(Region), Region[Sales] > 100000) = regions with >100k sales. SUMX() iterates rows and sums a custom expression: SUMX(Orders, Orders[Qty] * Orders[Price]) = revenue item-by-item (useful when Price varies per order).
Real-world DAX: High-value customers defined as those with total orders > 50,000. High Value Sales = CALCULATE(SUM(Sales[Amount]), FILTER(ALL(Sales), CALCULATE(SUM(Sales[Amount]), SALES[CustomerID]) > 50000)). This counts sales only for high-value customer IDs. Another example: Month-over-month growth = DIVIDE(Current Month Sales - Previous Month Sales, Previous Month Sales). These require nested CALCULATE() with date filters.
Performance: SUMX iterates and is slower than SUM on pre-aggregated measures; use only when necessary. FILTER on large tables (millions of rows) can timeout; pre-aggregate in Power Query instead. CALCULATE context ("which filters apply?") is crucial—filters FROM visuals override formula filters unless you use ALL() to clear them first.
Learn Pbi Dax Functions step by step with Syllab's free interactive Power Bi tutorial — runnable code examples, practice exercises and instant AI feedback, all free with no signup. Explore the full Power Bi course →