Microsoft Power BI Data Analyst Practice Question

The measure must divide the current filter-context value of SalesAmount by a total that ignores only the filters coming from the visual's ProductSubcategory axis while preserving every filter explicitly applied elsewhere (page, report, or slicer). CALCULATE with ALLSELECTED('Product') removes the visual's row/column filters but restores the outer filter context, so slicers on Product tables (for example, ProductCategory) and filters from other tables (Date, Geography, etc.) remain active. ALL('Product') removes all Product filters, including slicer filters, producing an incorrect denominator. ALLEXCEPT keeps the ProductSubcategory filter, so the percentage is always 100 %. REMOVEFILTERS() with no arguments clears all filters in the report, returning the grand total. Re-applying the selected subcategory in a FILTER expression again yields the numerator, not the total.