DAX Quiz

What does DAX stand for?

• Data Access Expressions

• Data Analysis Expressions

• Data Arithmetic Execution

• Data Aggregation XML

True or False: You can create both Calculated Columns and Measures using DAX.

• True

• False

What is the purpose of a Calculated Column?

• Perform aggregation across rows

• Calculate per row and store result in table

• Create dynamic calculations in visuals

• Override filters in a visual

Which scenario best suits using SUMX() instead of SUM()?

• You just need total of one column without calculations

• Need to apply row-by-row calculation before summing

• Summing across unrelated tables

• Aggregating text values

True or False: SUM() can handle row-level expression calculations like multiplying two columns before summing.

• True

• False

In DAX, which function returns text occurrence inside a string?

• LOOKUP()

• SEARCH()

• FIND()

• COUNTX()

What is the default starting position of FIND() if it's not specified?

• 0

• 1

• 2

• Depends on data type

True or False: A measure respects filter context, while a calculated column does not.

• True

• False

Which DAX formula calculates sum of UnitsSold * Price for each order?

• SUM(Orders[UnitsSold] * Orders[Price])

• SUMX(Orders, Orders[UnitsSold] * Orders[Price])

• CALCULATE(SUM(UnitsSold*Price))

• FILTER(Orders, UnitsSold*Price)

What does CALCULATE([TotalSales], Channel[Name]="Store") do?

• Ignores filters on TotalSales

• Returns TotalSales only for "Store" channel

• Calculates average sales

• Applies calculation only to a column