Quizalize logo
placeholder image to represent content

Calculated Fields with Dax - 3

Quiz by Support - BusinessPromoted .com

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
20 questions
Show answers
  • Q1
    How would you extract the birth year from a customer’s BirthDate field in Power BI?
    Use the MONTH function on the BirthDate column
    Use the DATEVALUE function on the BirthDate column
    Use the FORMAT function on the BirthDate column
    Use the YEAR function on the BirthDate column
    60s
  • Q2
    When should you use the RELATED function in Power BI?
    To count distinct values in a column
    To perform text manipulations
    To aggregate data in the same table
    To retrieve values from a related table on the one side of a one-to-many relationship
    60s
  • Q3
    Why is RELATED considered similar to VLOOKUP in Excel?
    Because it retrieves related values using predefined table relationships
    Because it formats date values
    Because it performs string concatenation
    Because it counts rows in a table
    60s
  • Q4
    What is a key requirement for the RELATED function to work?
    The data types of columns must be the same
    The column names must match exactly
    The tables must have identical structures
    There must be a valid one-to-many relationship between tables
    60s
  • Q5
    In what context does the RELATED function operate in Power BI?
    Row context
    Filter context
    Cell context
    Column context
    60s
  • Q6
    How does CALCULATE modify filter context in DAX?
    It applies a set of defined filters to an expression
    It counts the number of rows in a table
    It removes all filters from a table
    It formats data as a percentage
    60s
  • Q7
    What is the primary use of the CALCULATE function?
    To perform arithmetic operations
    To evaluate an expression under a set of defined filters
    To concatenate text values
    To convert data types
    60s
  • Q8
    When defining filters in CALCULATE, what type of expressions are valid?
    Aggregations of other measures
    Simple Boolean expressions with fixed values
    Complex text manipulations
    Date and time functions only
    60s
  • Q9
    How would you create a measure to calculate total orders only for bulk orders (order quantity > 1)?
    Use DISTINCTCOUNT on the order quantity column
    Use COUNTROWS with a filter on order quantity > 1
    Use CALCULATE with a filter on order quantity > 1
    Use RELATED to pull in the order quantity column
    60s
  • Q10
    What is the effect of using CALCULATE with a filter that overrides an existing filter context?
    It replaces the initial filter context with the new one
    It merges the new filter with the existing filter
    It duplicates the filter context
    It ignores the new filter and keeps the existing one
    60s
  • Q11
    How does CALCULATE handle conflicting filter contexts?
    It ignores both filters
    It returns an error
    It prioritizes the filter specified in CALCULATE
    It merges both filters together
    60s
  • Q12
    Why is it important to understand how CALCULATE modifies filter context?
    To simplify the data model
    To improve the performance of DAX queries
    To ensure accurate and expected results in measures
    To format numerical data correctly
    60s
  • Q13
    How would you respond to a VP’s concern about rising bike returns using DAX measures?
    Create measures for Bike Returns, Bike Sales, and Bike Return Rate, and analyze trends over time
    Use the SUM function to calculate total returns
    Generate a bar chart in PowerPoint
    Create a pivot table in Excel
    60s
  • Q14
    Why is it critical to know that DAX measures don’t sum visible values in reports?
    Because measures are static and don't change
    Because DAX uses cell references like Excel
    Because measures are calculated independently based on filter context
    Because measures always calculate totals only
    60s
  • Q15
    How does the ALL function interact with filter context in DAX?
    It merges filters from different tables
    It duplicates the existing filter context
    It removes all filters from the specified table or column
    It adds filters to the specified table or column
    60s

Teachers give this quiz to your class