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 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.