Set Identifier not Working

[#1]

Can anyone tell me why this expression is not selecting all records (ignoring the current selections)?

=(Sum({1<[B YearPeriod] = {"<=$(=Max([B YearPeriod]))"} >}[B Actual Amount]))

/(Sum({1<[B YearPeriod] = {"<=$(=Max([B YearPeriod]))"} >}[Budget Amount]))

[swuehl · Accepted solution]

You probably need to add the set identifier also to the max functions:

=(Sum({1<[B YearPeriod] = {"<=$(=Max({1}[B YearPeriod]))"} >}[B Actual Amount]))

/(Sum({1<[B YearPeriod] = {"<=$(=Max({1}[B YearPeriod]))"} >}[Budget Amount]))