Question 1 of 30
A retail company wants to analyze its sales data to understand the performance of its products in different regions. They have a dataset containing sales figures, product categories, and regions. The company wants to calculate the total sales for each product category in the \'North\' region while ignoring any filters applied to the product category. Which DAX expression should they use to achieve this?
`CALCULATE(SUM(Sales[TotalSales]), Sales[Region] = "North", ALL(Sales[ProductCategory]))`
`FILTER(Sales, Sales[Region] = "North" && Sales[ProductCategory] BLANK())`
`SUMX(FILTER(Sales, Sales[Region] = "North"), Sales[TotalSales])`
`SUM(Sales[TotalSales])`

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