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
)
lbendlin
Super User
Super UserALLEXCEPT is a rather blunt tool. Try something more surgical like REMOVEFILTERS.