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
Friends, many 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. This matters for both exams and interviews.
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students blank handling विसरतात आणि COALESCE, ISBLANK आणि "+ 0" सारखी functions एकत्र वापरताना गोंधळात टाकणारे results मिळवतात. Measure मध्ये 0 जोडला तर प्रत्येक combination साठी zero दिसतो आणि table visual चा आकार प्रचंड वाढू शकतो. जिथे zero ला खरंच अर्थ आहे तिथेच तो वापरा. हे exam आणि interview दोन्हीसाठी important आहे.
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students blank handling भूल जाते हैं और COALESCE, ISBLANK और "+ 0" जैसी functions मिलाकर उलझाने वाले results पाते हैं. Measure में 0 जोड़ने से हर combination के लिए zero दिखता है और table visual का size बहुत बढ़ सकता है. इसे वहीं इस्तेमाल करो जहाँ zero का सच में मतलब हो. यह exam और interview दोनों के लिए ज़रूरी है.
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.