I am trying to use a nested set analysis to get from the same table a count of rows after the last row that met certain condition.
Aggr(Count({$<[ColumnA]={'Value'},[ColumnB]={'No'},
Date={">=$(=aggr(Max({<[ColumnA]={'Value'},[ColumnB]={'Yes'}>}[Date]),[ColumnB]))"}
>} Date), [ColumnB]))
However, the table only shows values when it is filter on a specific value of Column B. and blank when the table is not filtered
