DAX ALLEXCEPT versus ALL & VALUES in Power Pivot

Hi

Cross posted with Mr Excel: https://www.mrexcel.com/board/thread...alues.1211045/

Had no response,

My question relates to the use of multiple CALCUALTE / CALCULATETBALE.
I've been using ALLEXCEPT to create a running total column by a certain criteria , customer or whatever, so EXCEPT that criteria,
but wanted to use ALL and VALUES, to see how it worked,

Please Login or Register  to view this content.

This returns a calculated column by criteria ( Item) . My question is what does the CALCULATETABLE actually do, the whole thing is wrapped in calculate anyway, I'm generally unsure about measures etc that have more than one Calculate / calculatetable,

and could do with a few pointers. I've attached the book I used for this example

Richard

1. Is this a Googlesheets Question? Excel does not have a CALCULATE function, as far as I can see...

2. If it IS ansd Excel question, please describe in words what you expect to see (instead of dreaming up non-existent functions)

Never used it, so I'll step aside!