Count Instances of events where the count of another event is >0

[sperry]

I have a dataset of events representing referrals to our services.

I need a measure to count of all instances  where an individual is accepted into more than 1 service over a period of time. The simplified data looks a bit like this

Date	Service	Status	Unique Identifier
1/01/2019	A	Accept	1
2/01/2019	B	Accept	1
3/01/2019	C	Decline	1
4/01/2019	D	Accept	2
5/01/2019	A	Decline	2
6/01/2019	B	Decline	2
7/01/2019	E	Accept	1
8/01/2019	A	Accept	3
9/01/2019	B	Accept	3

So there are 2 people who have been accepted into more than 1 service

[Zubair_Muhammad · Accepted solution]

@sperry 

You can use this MEASURE

Measure =
COUNTROWS (
    FILTER (
        VALUES ( Table1[Unique Identifier] ),
        CALCULATE ( DISTINCTCOUNT ( Table1[Service] ), Table1[Status] = "Accept" ) > 1
    )
)

[sperry]

Perfect..Thanks