Question

You are building a sales report in Power BI. A [Total Sales] measure already exists and correctly sums the SalesAmount column. On a matrix visual, products are placed on rows and you need a measure named [% of All Products] that shows each product's sales as a percentage of the grand total across ALL products, so the value stays constant regardless of which product row it appears on. Which DAX definition should you use?

Accepted Answer

% of All Products = DIVIDE([Total Sales], CALCULATE([Total Sales], ALL('Product')))

Answer

% of All Products = DIVIDE([Total Sales], CALCULATE([Total Sales], ALLSELECTED('Product')))

Answer

% of All Products = DIVIDE([Total Sales], [Total Sales])

Answer

% of All Products = DIVIDE([Total Sales], CALCULATE([Total Sales], KEEPFILTERS('Product')))