I have a table where one id has multiple entries. For each id, as long as there is an entry where mark is "1", it is considered marked. i want to know how many ids are marked. in this case there are 2.
thank you
This seems like what you want...
UniqueCount(If([Mark] = 1,[ID]))