Forum Discussion
Solved
ALLEXCEPT stops working as expected when i remove a field from my visual. What am i missing?
I'm trying to create a "Market Size" formula that calculates the relevant market size per brand. "Market Size" is considered as the sum of sales for all countries that brand is sold in. Exam...
ALLEXCEPT is a rather blunt tool. Try something more surgical like REMOVEFILTERS.
Var countries = values( 'Sales'[Country] )
Return
CALCULATE(
SUM('Sales'[Sales]),
ALLSELECTED(),
countries
)
Hi 03clacey,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Thanks and regards