Label data rows based on column values & calculate measures for each label group

@Er3n you could take a look at this example trying to identify the trips

The relevant Column Expression goes like this:

if (equals(column("Counter"),1) 
         && // && means AND
        (   isMissing(column("Status"))
         || isNaN(column("Status")) // || means OR
        )
        && equals(column("Total cumulated distance"), 0)
    )
    {column("rank")}
else {toNull("")}    
2 Likes