Ignore Selection in P() or E() with filter selection

[saumyashah90]

I have this expression.

Comparison between two months.  RightMonth is the current selection(under [Asof Date])

"Resigned"=& Count(DISTINCT{<[Employee ID] = e({<[Asof Date] = {'$(vRightMonth)'}>}[Employee ID]), [Employee ID] = p({<[Asof Date] = {'$(vLeftMonth)'}>}[Employee ID])>}[Employee ID])

This gives me result of count common between Left and Right Month.

I want to find employee count which were present in leftMonth(lowermonth) but not present in rightMonth(highermonth).

This will give me people who resigned.

Whats wrong?

I cannot do anything in script. need to to do in UI only with expression.

Your help would be thankful

[sunny_talwar · Accepted solution]

Try this

"Resigned" & Count(DISTINCT{<[Employee ID] = e({<[Asof Date] = {'$(vRightMonth)'}>} [Employee ID]) * p({<[Asof Date] = {'$(vLeftMonth)'}>}[Employee ID])>} [Employee ID])