Hi Justin! You can do this using something like this:
WINDOW_SUM(SUM(IIF([Status]="L2", 1, 0))) = 0
Set that with [Alert (group)] as a partitioning field, of course. Note that this solution requires that [Status] be in the level of detail. If it isn't, then we'd need to use a different solution.
Thanks for taking the time to make a suggestion. I see where you're going with this.
How would I expand the calculation if I had a number of statuses that I wanted considered? For example, if statuses "L3", "L4" were not showing too?
Like this, right?
WINDOW_SUM(SUM(IIF[Status]="L2" OR [Status] = "L3" OR CONTAINS([Status], "L1"),1,0)))=0
Seems to do the job
You're welcome! And that should work, yes.