Unique Count on Filtered Table

#1

image

I have the table above and want to count the unique people who have completed a task. My formula must be wrong b/c I’m getting 3 (John, John, Andy) instead of 2 (John and Andy).

My formula is:
=CountUnique(Test.filter([Completed Task?]="Yes"))

Thanks!

#2

Can you try

Test. Filter (completedTask=yes).name.unique().count()

Let me know if it works!

1 Like
#3

That worked, thanks!

So if I’m understanding the Test.filter returns a filtered table that it was then counting unique rows of (I would think the answer would still be 2), but with your addition, I’m then calling just the Name column of the filtered table and counting the unique values from that, which makes sense. thanks!

1 Like