🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate20 / 150
Question 20 of 150
You are building a measure in a Power BI semantic model to display each product category's sales as a percentage of the grand total across all categories. The report page contains a matrix visual sliced by Product[Category]. Your base measure [Total Sales] = SUM(Sales[Amount]) works correctly per row. Which DAX expression correctly computes the percent-of-total for each category, regardless of which categories are visible in the current filter context?
Reviewed for accuracy · Report an issueNext question