DAX Basics interview questions

1. A.an aggregation expression evaluated at query time under the current filters and not stored per row
2. B.an iterator that walks a table row by row, computing an expression on each and totaling the results
3. C.a row-by-row expression evaluated at refresh time and stored physically, consuming model memory
4. D.the set of filters from slicers, rows, columns, and visuals that constrains which data an expression evaluates over

Answer + AI explanation with Pro

1. A.Calculated column
2. B.Measure
3. C.Filter context
4. D.CALCULATE

Answer + AI explanation with Pro

1. A.Calculated column — the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions
2. B.Calculated column — an iterator that walks a table row by row, computing an expression on each and totaling the results
3. C.Calculated column — the evaluation environment that knows the current single row, present in column expressions and iterators
4. D.Calculated column — a row-by-row expression evaluated at refresh time and stored physically, consuming model memory

Answer + AI explanation with Pro

1. A.the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions
2. B.an iterator that walks a table row by row, computing an expression on each and totaling the results
3. C.an aggregation expression evaluated at query time under the current filters and not stored per row
4. D.a row-by-row expression evaluated at refresh time and stored physically, consuming model memory

Answer + AI explanation with Pro

1. A.Measure
2. B.Row context
3. C.Calculated column
4. D.SUMX

Answer + AI explanation with Pro

1. A.Measure — the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions
2. B.Measure — an aggregation expression evaluated at query time under the current filters and not stored per row
3. C.Measure — an iterator that walks a table row by row, computing an expression on each and totaling the results
4. D.Measure — the set of filters from slicers, rows, columns, and visuals that constrains which data an expression evaluates over

Answer + AI explanation with Pro

1. A.the set of filters from slicers, rows, columns, and visuals that constrains which data an expression evaluates over
2. B.the evaluation environment that knows the current single row, present in column expressions and iterators
3. C.the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions
4. D.an iterator that walks a table row by row, computing an expression on each and totaling the results

Answer + AI explanation with Pro

1. A.SUMX
2. B.Filter context
3. C.Calculated column
4. D.Row context

Answer + AI explanation with Pro

1. A.Row context — the evaluation environment that knows the current single row, present in column expressions and iterators
2. B.Row context — an aggregation expression evaluated at query time under the current filters and not stored per row
3. C.Row context — the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions
4. D.Row context — a row-by-row expression evaluated at refresh time and stored physically, consuming model memory

Answer + AI explanation with Pro

1. A.the evaluation environment that knows the current single row, present in column expressions and iterators
2. B.the set of filters from slicers, rows, columns, and visuals that constrains which data an expression evaluates over
3. C.an iterator that walks a table row by row, computing an expression on each and totaling the results
4. D.an aggregation expression evaluated at query time under the current filters and not stored per row

Answer + AI explanation with Pro

1. A.Calculated column
2. B.CALCULATE
3. C.Filter context
4. D.Row context

Answer + AI explanation with Pro

1. A.Filter context — an aggregation expression evaluated at query time under the current filters and not stored per row
2. B.Filter context — an iterator that walks a table row by row, computing an expression on each and totaling the results
3. C.Filter context — the set of filters from slicers, rows, columns, and visuals that constrains which data an expression evaluates over
4. D.Filter context — a row-by-row expression evaluated at refresh time and stored physically, consuming model memory

Answer + AI explanation with Pro

1. A.a row-by-row expression evaluated at refresh time and stored physically, consuming model memory
2. B.the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions
3. C.an iterator that walks a table row by row, computing an expression on each and totaling the results
4. D.the evaluation environment that knows the current single row, present in column expressions and iterators

Answer + AI explanation with Pro

1. A.Filter context
2. B.CALCULATE
3. C.Row context
4. D.Calculated column

Answer + AI explanation with Pro

1. A.CALCULATE — the evaluation environment that knows the current single row, present in column expressions and iterators
2. B.CALCULATE — an iterator that walks a table row by row, computing an expression on each and totaling the results
3. C.CALCULATE — the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions
4. D.CALCULATE — the set of filters from slicers, rows, columns, and visuals that constrains which data an expression evaluates over

Answer + AI explanation with Pro

1. A.the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions
2. B.a row-by-row expression evaluated at refresh time and stored physically, consuming model memory
3. C.the evaluation environment that knows the current single row, present in column expressions and iterators
4. D.an iterator that walks a table row by row, computing an expression on each and totaling the results

Answer + AI explanation with Pro

1. A.Calculated column
2. B.Row context
3. C.SUMX
4. D.CALCULATE

Answer + AI explanation with Pro

1. A.SUMX — an iterator that walks a table row by row, computing an expression on each and totaling the results
2. B.SUMX — an aggregation expression evaluated at query time under the current filters and not stored per row
3. C.SUMX — a row-by-row expression evaluated at refresh time and stored physically, consuming model memory
4. D.SUMX — the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions

Answer + AI explanation with Pro