DAX ALLEXCEPT vs ALL & VALUES

Hi have a pivot table where I have used ;

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

in the pivot these both give the same result a total for the items ignore everything else, this is attached,
but if I go to studio or Table Edit DAX and run the following

EVALUATE
ADDCOLUMNS( Table1,
"N", CALCULATE( [Tsales] , ALLEXCEPT(Table1,Table1[Item])))

EVALUATE
ADDCOLUMNS( Table1,
"M", CALCULATE( [Tsales], ALL( Table1), VALUES( Table1[Item] ) ))



I get two different result the all values seems to ignore the values and bring back the overall total? what am I doing wrong?

Richard.

Ok, but I still don't see why in DAX studio, it does not work when say this from sqlbi does.

Please Login or Register  to view this content.

REMOVE is not available in p pivot, which is what I'm using, but the construction is the same, and in a pivot table works better
than ALLEXCEPT as you have to have the column being 'excepted' in the table but with ALL VALUES it need not be present.

Richard.

Thanks for the links, I will have a read through, it's not a major practical issue I was just curious.

I'll mark this up,

Thanks to both of you.

Richard.