Count with Multiple Selection Slicer

[jdiruzza]

I am trying to find the amount of people that transferred between a group of departments during each month:

The data:

EMPLOYEE	MONTH	DEPT	PRIOR MO DEPT	TRANSFER
100216	FEB	5501	5501	N
100216	JAN	5501	2255	Y
100216	DEC	2255	N/A	N/A

If the slicer is set to 5501 the expected value is 1.

If the slicer is set to 5501 OR 2255 the expected value is 0.

I am looking for a measure with this formula.

Thanks!

[DOLEARY85]

Hi,

try this:

Measure 9 = calculate(count('Table (5)'[Employee]),'Table (5)'[TRANSFER]="y")

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍