Forum Discussion
CarlsBerg999
Helper V
3 years agoMeasure: 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 |
Simple enough
1 Reply
- CNENFRNL
Community Champion
Simple enough