Using set identifier with multiple set analysis

[#1]

Maybe its just the syntax that's screwing me up.  My issue is i want to do the set analysis say for Year=2016, and Month=Jul, exluding all selections.

Sum({1<[Year]={'2016'}>*<[Month]={'Jul'}>}Sales)

This behaves the same way with or without the 1.  The year and month sets work on their own, and if i combine the 1 with only one field of set analysis it works, but not all at the same time.

Any Ideas?

Thanks

[sunny_talwar · Accepted solution]

Try this:

Sum({1<[Year]={'2016'}, [Month]={'Jul'}>}Sales)