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,
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,Please Login or Register to view this content.
and could do with a few pointers. I've attached the book I used for this example
Richard
Bookmarks