topic Re: Set Analysis Ignoring Selection in App Development

Set Analysis Ignoring Selection

acbishop2 — Thu, 05 Apr 2018 21:14:49 GMT

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

Re: Set Analysis Ignoring Selection

Digvijay_Singh — Thu, 05 Apr 2018 21:34:44 GMT

What I understand is, the modifier {Team]={'Original'} overrides the selections in the Team field. So whatever you choose, this particular chart would not be affected by the selections in Team field. the {$<>} allows to make selections in other fields and they will impact the result.

I think you need something like this, need to test the syntax -

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

Re: Set Analysis Ignoring Selection

acbishop2 — Thu, 05 Apr 2018 21:47:44 GMT

You did it again, Digvijay!

Here's the solution with final syntax:

SUM({$<[Team] = {'Original'}>*<[Team]=P([Team])>*<Month = {"$(=Month($(vMaxDate)))"}>}[Lead Goal])

I hadn't ever seen the P() function. Thanks for introducing it to me!

Re: Set Analysis Ignoring Selection

sunny_talwar — Fri, 06 Apr 2018 00:02:02 GMT

This might have worked also

SUM({$<[Team] = {'Original'}*P([Team]), Month = {"$(=Month($(vMaxDate)))"}>}[Lead Goal])

Re: Set Analysis Ignoring Selection

sunny_talwar — Fri, 06 Apr 2018 00:03:02 GMT

Actually this should work even better

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