Counting a slice without syncing

Summary table

Also tried with "COUNT(SELECT(D to W[Word], and([Validation]=1,[Set aside]<>[Session])))" but result was the same (only worked after sync)

Hidden Ref-type virtual column in the table whose rows are being counted