Forum Discussion

jdiruzza's avatar
jdiruzza
Frequent Visitor
3 years ago

Count with Multiple Selection Slicer

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

 

The data:

EMPLOYEEMONTHDEPTPRIOR MO DEPTTRANSFER
100216FEB55015501N
100216JAN55012255Y
100216DEC2255N/AN/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!

Need Help

1 Reply

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    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 👍