13. DAX: Data Analysis Expressions
13.19 Other Useful Functions
| Function | Purpose | Example |
|---|---|---|
ISBLANK |
Tests for blank | IF(ISBLANK([Sales LY]), "New", "Existing") |
COALESCE |
First non-blank value | COALESCE([Total Sales], 0) |
BLANK() |
Returns blank | IF([Total Orders] = 0, BLANK(), [Total Orders]) |
SUMMARIZE |
Group-by table | SUMMARIZE(Orders, DarkStore[City]) |
ADDCOLUMNS |
Adds calculated columns to a table expression | see Top 10 Stores above |
CALCULATETABLE |
CALCULATE that returns a table | CALCULATETABLE(Orders, 'Date'[Year] = 2025) |
CROSSFILTER |
Changes relationship direction for one calculation | CALCULATE([Total Orders], CROSSFILTER(Orders[Customer ID], Customer[Customer ID], BOTH)) |
ISINSCOPE |
TRUE when a column is the current level in a hierarchy | used for level-specific measures in matrices |
ROUND |
Rounds a number | ROUND([Avg Delivery Time (mins)], 1) |
DAX formatting tip
Keep one argument per line for long formulas, indent nested functions, and give measures clear names such as Sales LY or Cancellation Rate. Free online formatters such as DAX Formatter by SQLBI can tidy your code automatically.
Ravindra Bagale's Tip
Mitrano, khup students forget blank handling and get confusing results when they combine functions like COALESCE, ISBLANK and "+ 0". Adding 0 to a measure shows zeros for every combination and can explode the size of a table visual. Use it only where zero really has meaning. He exam aani interview doghansathi important aahe.
Thodkyaat sangaycha tar (quick recap)
Base measures aadhi, measure filter context madhe chalto, CALCULATE filters badalto, DIVIDE vapra, aani time intelligence sathi marked Date table hava. Samjla ka? Nasel tar 13.3 aani 13.8 punha ekda vacha – baki sagla tyavar ubha aahe. Aata pudhe jaauya visuals kade.