Master Power Bi Dax Common Patterns with 158 free flashcards. Study using spaced repetition and focus mode for effective learning in Data Science.
Sample card
Difference between calculated column and measure?
Column: computed row-by-row at refresh; stored in model; uses row context.
Measure: computed at query time; aggregates; uses filter context.
Q · 1 of 158
Difference between calculated column and measure?
Q · 2 of 158
Basic measure: total sales?
Q · 3 of 158
Distinct customer count?
Column: computed row-by-row at refresh; stored in model; uses row context.
Measure: computed at query time; aggregates; uses filter context.
Total Sales := SUM(Sales[Amount])
Customers := DISTINCTCOUNT(Sales[CustomerId])
PY Sales := CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date]))
YoY % := DIVIDE([Total Sales] - [PY Sales], [PY Sales])
YTD Sales := CALCULATE([Total Sales], DATESYTD('Date'[Date]))
Bike Sales := CALCULATE([Total Sales], Products[Category] = "Bikes")
DIVIDE handles divide-by-zero gracefully (returns BLANK or 3rd arg). Slash returns infinity error.
Modifies filter context. Replaces or adds filters before evaluating its expression.
CALCULATE([Total Sales], ALL(Products[Category]))
ALLEXCEPT(Products, Products[Category]) — clears all filters on Products except Category.
%Total := DIVIDE([Total Sales], CALCULATE([Total Sales], ALLSELECTED()))
Flashcards
Flip to reveal
Focus Mode
Spaced repetition
Multiple Choice
Test your knowledge
Type Answer
Active recall
Learn Mode
Multi-round mastery
Match Game
Memory challenge