Using ALLEXCEPT versus ALL and VALUES - SQLBI
In the example code, ALLEXCEPT removes any filter from the Product table apart from the one on the Brand column. When Brand is part of the filter context, as it happens for all the rows in the green box, the formula computes the correct value. But in the red boxes, the filter context contains only the Owner column, and Brand is not part of it.
DA: 1 PA: 67 MOZ Rank: 92 Up or Down: Up