DAX Formulas and Functions Flashcards
6 cards from real Microsoft Power BI 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 DAX function FILTER() return?
Answer: A filtered table based on a Boolean condition
FILTER() returns a table that contains only the rows satisfying the specified Boolean condition, and is commonly nested inside CALCULATE().
What is the purpose of the DAX VAR keyword?
Answer: Declares a variable to store an intermediate result, improving readability and performance
VAR allows you to store an intermediate DAX expression result in a named variable, making complex formulas easier to read and avoiding repeated computation.
Which DAX function returns a table with all combinations of values from two or more columns?
Answer: CROSSJOIN()
CROSSJOIN() returns a table that is the Cartesian product of all rows from each specified table.
What does ALLSELECTED() do in DAX?
Answer: Removes explicit filters while keeping the outer query context from user selections like slicers
ALLSELECTED() removes filters from the specified table or columns but preserves the outer query context, such as slicer selections, making it useful for percentage-of-visible-total calculations.
What does the IF() function do in DAX?
Answer: Evaluates a condition and returns one of two values depending on whether it's TRUE or FALSE
IF() evaluates a logical condition and returns the first value if TRUE or the second value (or BLANK) if FALSE.
What is the purpose of the KEEPFILTERS() modifier in CALCULATE()?
Answer: Prevents CALCULATE from overriding existing filters, adding the new filter as an intersection instead
KEEPFILTERS() modifies how CALCULATE applies a filter argument, intersecting it with existing filters rather than replacing them.