Forum Discussion

CarlsBerg999's avatar
CarlsBerg999
Icon for Helper V rankHelper V
3 years ago
Solved

Measure: Count items in a sub-group context

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

1 Reply