4 Replies Latest reply: Apr 5, 2018 8:03 PM by Sunny Talwar RSS

    Set Analysis Ignoring Selection

    Aaron Bishop

      Hi All,

       

      I have an expression in set notation that I need to be affected by the filter I choose. From what I understand, the {$<>} notation is supposed to be affected by the filters/selections, yet it isn't changing in this case. My expression is:

       

      Sum({$<[Team] = {"Original"},Month = {"$(=Month($(vMaxDate)))"}>}[Lead Goal])

       

      In other words, the value displayed should be the current month's Lead Goal for the Original Team. It gives me the correct value, but when I use my [Team] filter, it stays the same. If I select a [Team] other than "Original", I want the value to be 0.

       

      Thank you in advance for shedding some light on this.

       

      Aaron