Question 1 of 30
A data analyst is working on a sales report using Power BI Desktop. The report includes a measure that calculates the total sales amount using the formula:
\text{Total Sales} = \sum_{i=1}^{n} \text{Sales Amount}_i $$
re \( n \) is the number of transactions. The analyst wants to create a visual that shows the total sales per region, but they also want to filter the data to exclude any transactions where the sales amount is less than $100. Which of the following approaches should the analyst take to ensure that the visual accurately reflects the total sales per region while applying the necessary filter?
Create a new measure that calculates total sales with the filter applied directly in the measure definition using DAX.
Use the existing total sales measure and apply a visual-level filter to exclude sales amounts less than $100.

Preparing for Microsoft PL-900 Microsoft Power Platform Fundamentals? 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