topic Re: Set Analysis Expression in App Development

Set Analysis Expression

ltc — Fri, 02 Apr 2021 07:44:38 GMT

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!

Re: Set Analysis Expression

zzyjordan — Thu, 10 Jan 2019 05:10:05 GMT

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

ZZ

Re: Set Analysis Expression

ltc — Thu, 10 Jan 2019 05:13:26 GMT

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

Re: Set Analysis Expression

zzyjordan — Thu, 10 Jan 2019 06:01:09 GMT

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

Re: Set Analysis Expression

ltc — Thu, 10 Jan 2019 06:02:57 GMT

yes, that makes sense. thank you so much!