ALL, ALLEXCEPT and ALLSELECTED

The ALL family removes or ignores parts of the filter context so measures can show totals, rankings, or percentages that behave correctly inside visuals and slicers.

• Removes filters from the specified columns or entire table.
• Ignores both page slicers and visual row/column filters for those columns.
• Common in % of Grand Total and static RANKX denominators.

// Remove all filters on the Product table
ALL ( Product )

// Remove filters on Category only
ALL ( Product[Category] )

// Use inside CALCULATE
% of Total Sales =
DIVIDE(
    [Total Sales],
    CALCULATE( [Total Sales], ALL ( Product[Category] ) )
)

• Removes all filters on a table except the columns you list.
• Keeps the current visual row context for those columns (e.g., Category).
• Ideal for rank within category or segment-level percentages.

// Keep Category filter, remove Product and other columns
ALLEXCEPT ( Product, Product[Category] )

Rank in Category =
RANKX(
    ALLEXCEPT ( Product, Product[Category] ),
    [Total Sales],
    ,
    DESC
)

• Removes filters from inside the visual, but keeps page/report slicers and cross-filtering from other visuals.
• Reflects what the user selected on the page, not the full database.
• Use for % of Visible Total in the current report view.

% of Selected Total =
DIVIDE(
    [Total Sales],
    CALCULATE( [Total Sales], ALLSELECTED ( Product ) )
)

// Often used with KEEPFILTERS for advanced patterns
CALCULATE(
    [Total Sales],
    ALLSELECTED ( 'Date'[Year] )
)