Question

How do I calculate the percentage contribution of each category while considering multiple slicers?
I need a Power BI measure that calculates the percentage contribution of each category (e.g., product, region) to the total, ensuring that the percentage dynamically updates based on user-applied slicers. How can I use DAX functions like CALCULATE(), ALL(), or ALLSELECTED() to ensure that the measure properly accounts for different filtering scenarios?

Answer 1

You can calculate the percentage contribution dynamically using CALCULATE(), ALL(), or ALLSELECTED() to control filter context.

1. Create the Percentage Contribution Measure

% Contribution =
VAR TotalSales = CALCULATE([Total Sales], ALLSELECTED('Sales'))
RETURN
DIVIDE([Total Sales], TotalSales, 0)

2. Explanation

ALL SELECTED ('Sales') checks that total consider active slicer filters while filtering out row-level filters (filtering by column, for example).

DIVIDE() avoids the division by zero problems.

3. How It Works

In this case, if the user applies a filter by Region, the percentage will be evaluated for only those selected regions.

When no filter is applied, it shows the overall contribution of each category in sales.