Set Analysis Expression

[ltc]

I'm doing something wrong with my set analysis expression, but not sure how to fix it.  Please help!

Sum({<[Org Symbol]={'1234'}, or {'5678'}>}[Budget Amount])

It works when I just do set analysis on one org symbol, like 1234.  But I need to do both org symbols 1234 & 5678, so my problem is with the "or" part.

Thanks!

[zzyjordan · Accepted solution]

Hi,
Have you tried this?
Sum({<[Org Symbol]={'1234','5678'}>}[Budget Amount])

ZZ

[ltc]

Nope, I had not tried that, but this seemed to be the answer.  So the "or" is implied with the comma, yes?

[zzyjordan]

yes and no.
Set analysis actual defines a set of data for the calculation, you can regard this is a subset of the original data set, and the calculation(sum, avg, etc.) only happens within the subset. so we can't say use comma to replace 'Or' as the values inside {} just defines the dataset where [Org Symbol] contains value inside the {}. hope this makes sense.

ZZ

[ltc]

yes, that makes sense.  thank you so much!