Summing for multiple row values with =CALCULATE

[jk-vtti]

Hello,

Simple question: I have linked tables, one with my main data, and other look-up tables. I'm trying to do a compound count of the files we have at five stages of production (ex. Stage 1 = Stage 1 count + Stage 2 ... Stage 5). There are several file types I'm accounting for, and the file type determines which stage a file is in (several file types are grouped in each stage). I'm using =CALCULATE(SUM([Table with total counts and file types]), Stages table [stage number column]=1, Stages table [stage number column] =2 ...). I'm getting (blank), not error, as a return. I tried using =OR in a =CALCULATE function, but can only include two values in =OR (this did sum properly, however).

How can I count for more than two stages (row value) in a =CALCULATE function? Do I need another function?

Thanks,

Joel

 

[MD610]

The filter parameters in a CALCULATE are treated like ANDs when separated by a comma. Instead of the comma's, try using this || which is the symbol for OR.

Alternatively, you could try something like [stage number column]>=1 && [stage number column] <= 5
for the filter parameter of the CALCULATE.