WorksheetsDAX Quiz
Total questions: 10
Worksheet time: 5mins
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
