DAX Formulas and Functions Flashcards
6 cards from real Microsoft Certified Data Analyst Associate practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 DAX Formulas and Functions flashcards as text
What does the FILTER function return in DAX?
Answer: A filtered table based on a condition
FILTER returns a table containing only the rows that satisfy the specified Boolean expression.
Which DAX function returns the number of rows in a table or the number of non-blank values in a column?
Answer: COUNTROWS
COUNTROWS counts the number of rows in a table or in a table returned by an expression.
What does the EARLIER function do in DAX?
Answer: References an outer row context within a nested row context iteration
EARLIER accesses the value of a column from an outer row context when working in nested iterations, commonly used in calculated columns with FILTER.
What is context transition in DAX?
Answer: The process where CALCULATE converts a row context into an equivalent filter context
Context transition occurs when CALCULATE converts the current row context into an equivalent filter context, which is critical to understand when using measures in calculated columns.
Which DAX function returns a table with all combinations of values from multiple columns?
Answer: CROSSJOIN
CROSSJOIN returns a table that is the Cartesian product of all specified tables, containing every combination of rows.
What does the HASONEVALUE function return in DAX?
Answer: TRUE if the specified column has exactly one value in the current filter context
HASONEVALUE returns TRUE when the filter context has reduced a column to exactly one distinct value, useful for conditional measure logic.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com — Passing score, renewal, fees, time limit, score validity, retake fee, exam information · verified Oct 2026
- pearsonvue.com — Test delivery · verified Oct 2026