🔥 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