Question 1 of 24
A retail company is analyzing its sales data to understand the performance of its various product categories over the last quarter. The data analyst creates a measure to calculate the total sales amount using the formula:
\text{Total Sales} = \sum_{i=1}^{n} (\text{Quantity Sold}_i \times \text{Price}_i) $$
ever, the analyst notices that the total sales amount is significantly different when filtered by different regions. What could be the reason for this discrepancy in the evaluation context, and how should the analyst approach this issue to ensure accurate reporting?
The measure is context-sensitive and may yield different results based on the applied filters, such as region or time period.
The measure is static and should provide the same result regardless of any filters applied.

Preparing for Microsoft PL-300 Microsoft Power BI Data Analyst? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free