Which of the following options performs calculations by using
specific values, or arguments, in a particular order or structure?
Calculated measure
Date table
DAX function
Formula bar
What is helpful for showing data at a different level of detail for
analysis?
Formula bar
DAX function
Date table
Calculated measure
Answer Calculated measure is correct.
A calculated measure is helpful for showing data at a different level of detail
for analysis. It is a calculated field based on an existing measure in the data
with a formula and aggregation applied to refine the data.
Which of the following functions will modify the filter context prior
to the evaluation?
AVERAGE
REPLACE
ISBLANK
CALCULATE
Answer CALCULATE is correct.
The CALCULATE function modifies the filter context prior to the evaluation.
It is particularly useful when users are calculating time intelligence
measures such as year-to-date sales or year-over-year growth.
This study source was downloaded by 100000903111493 from CourseHero.com on 02-04-2026 14:41:46 GMT -06:00
https://www.coursehero.com/file/249326297/DSC570-WEEK-4docx/
specific values, or arguments, in a particular order or structure?
Calculated measure
Date table
DAX function
Formula bar
What is helpful for showing data at a different level of detail for
analysis?
Formula bar
DAX function
Date table
Calculated measure
Answer Calculated measure is correct.
A calculated measure is helpful for showing data at a different level of detail
for analysis. It is a calculated field based on an existing measure in the data
with a formula and aggregation applied to refine the data.
Which of the following functions will modify the filter context prior
to the evaluation?
AVERAGE
REPLACE
ISBLANK
CALCULATE
Answer CALCULATE is correct.
The CALCULATE function modifies the filter context prior to the evaluation.
It is particularly useful when users are calculating time intelligence
measures such as year-to-date sales or year-over-year growth.
This study source was downloaded by 100000903111493 from CourseHero.com on 02-04-2026 14:41:46 GMT -06:00
https://www.coursehero.com/file/249326297/DSC570-WEEK-4docx/
