Hi
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 criteiria,
but wanted to use ALL and VALUES, to see how it worked,
The formula I used was
Ok, so CALCULATETABLE because VALUES is a table function, but not sure why I have to use it , all I know is that until I added it it didn't work.
It's nested within the calculate so why is it necessary, any help , pointers , reading suggestions welcome.
Richard.
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 criteiria,
but wanted to use ALL and VALUES, to see how it worked,
The formula I used was
Excel Formula:
VAR currentIndex = AllandValues[dex]
VAR anser =
CALCULATE (
[avsales],
FILTER ( ALL ( AllandValues ), AllandValues[dex] <= currentIndex ),
CALCULATETABLE ( VALUES ( AllandValues[Customer] ) )
)
RETURN
anser
Ok, so CALCULATETABLE because VALUES is a table function, but not sure why I have to use it , all I know is that until I added it it didn't work.
It's nested within the calculate so why is it necessary, any help , pointers , reading suggestions welcome.
Richard.