Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are tasked with optimizing a sales report for a retail company. The report needs to display the total sales for each product category, leveraging a data model that includes a 'Sales' table with columns 'ProductID', 'CategoryID', and 'SalesAmount'. The solution must efficiently handle large datasets and provide accurate results. Considering the requirements for performance and accuracy, which of the following DAX expressions would you use to correctly calculate the total sales for each product category? (Choose one correct option)