Order of Operations in Set Analysis

[P_McDermott]

Hi There,

I have a measure where I am using Set Analysis to limit my data to the last month.

Here is the full statement where the variable vLastMonth is equal to Month(NOW())-1

Sum({1<MonthNum={'$(vLastMonth)'}>}ASCAdj*LBS)+Sum({1<MonthNum={'$(vLastMonth)'}>}SterAdj*LBS))/Sum({1<MonthNum={'$(vLastMonth)'}>}Kgs)

My question is in the following:

Sum({1<MonthNum={'$(vLastMonth)'}>}ASCAdj*LBS)

will the result be Sum(ASCAdj)*LBS where only the value for ASCAdj will be filtered by the Set Analysis

or

Will the result be Sum(ASCAdj*LBS) where both values ASDAdj & LBS are filtered by the Set Analysis?

Or would it be best to have it like:

(Sum({1<MonthNum={'$(vLastMonth)'}>}ASCAdj)*Sum({1<MonthNum={'$(vLastMonth)'}>}LBS))+(Sum({1<MonthNum={'$(vLastMonth)'}>}SterAdj)*Sum({1<MonthNum={'$(vLastMonth)'}>}LBS))
/Sum({1<MonthNum={'$(vLastMonth)'}>}Kgs)

Thanks for your help

[sunny_talwar · Accepted solution]

Both will be filtered for the last month. Think of it as a row by row evaluation where set analysis will only pick rows where MonthNum  = 1 and for those rows do ASCAdj*LBS and then sum it

[P_McDermott]

Thanks So Much!