Measure: Count items in a sub-group context

[CarlsBerg999]

Hi,

I'm trying to create a measure that counts how many distinct ID's have the Phase 1, but does not have the subsequent phase 3.  So in the example below, the answer would be: 2 (ID's 10560 and 10481).

What im having issues with is defining a context that includes the values of each ID for this evaluation. Any help?

ID	Life Cycle Status Text	Phases
10559	Won	1
10559	Won	2
10559	Won	3
10559	Won	4
10560	Won	1
10560	Won	2
10481	Lost	1

[CNENFRNL · Accepted solution]

Simple enough