Which DAX function should be used to calculate the ratio of a subcategory sales to the total sales regardless of any category filter?

Question

Power BI — Medium

Which DAX function should be used to calculate the ratio of a subcategory sales to the total sales regardless of any category filter?

Accepted Answer

To calculate the ratio of subcategory sales to total sales regardless of category filters, the DAX function should ignore any filters on the category. The correct answer, DIVIDE(SUM(Sales), CALCULATE(SUM(Sales), ALL(Category))), achieves this by using ALL(Category) to remove category filters. Other options are incorrect because they either remove all filters or consider all selected values.