Current Slicer Selection:
Category: Clothing
Product: Jeans
Goal: Calculate totals by ignoring specific filters.
Only "Jeans" are visible initially. Watch how the functions un-hide rows.
Ready...
💻 DAX Formula
-- Scenario 1: Ignore ALL filters (Grand Total)
MEASURE All_Sales = CALCULATE( SUM(Sales[Amt]),
ALL( Sales )
) -- Removes Category AND Product filters
-- Scenario 2: Keep Category, Ignore Product
MEASURE Cat_Subtotal = CALCULATE( SUM(Sales[Amt]),
ALLEXCEPT( Sales, Sales[Category] )
) -- Keeps "Clothing", removes "Jeans"