Create A Measure Affected only by Specific Slicers

Hi Anonymous ,

If i understand you correctly, ALLEXCEPT() function might be helpful for you.

Please refer to below measure and see if the result achieve your expectation.

total_sales = CALCULATE(SUM('Table'[Sales]),FILTER(ALLEXCEPT('Table','Table'[Customer Name]),'Table'[date]>201910))
total_ROM = CALCULATE(SUM('Table'[ROM]),FILTER(ALLEXCEPT('Table','Table'[Market]),'Table'[date]>201910))

Here's my sample data and result would be shown as below.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.