DAX - Precedence Part 3: ALLEXCEPT vs. ALL w/ VALUES ...
OK, that was a bit unexpected. ALLEXCEPT() returned the same results as pure ALL(). So ALLEXCEPT() does *not* preserve the pivot context of columns NOT on the pivot, whereas VALUES() *does* pick those up. I’m not sure if that’s intentional on the part of the PowerPivot team, or if it’s just a quirk. Summary
DA: 94 PA: 85 MOZ Rank: 11 Up or Down: Up