Count Filter Help

I’m trying to count instances of a unique value from a separate table. The test doc is here (“Count Instances from Table”):

I’m sure it’s a formula problem. My formula looks like this:

Hardware.[Installed Software].Filter(Contains(thisRow)).Count()

My formula only shows “0”. Anyone better at formulas than me know what I’m doing wrong?

Either of these methods should work!

@Christiaan_Huizer do you want to enlighten us and explain why?


1 Like

hi @Scott_Collier-Weir , thanks for asking

Every filter evaluates item per item and we call these items the currentvalues (the current item being evaluated) and when you check all values in a column, it is a matter of habit if you use the currentvalue explicit or implicit. Most of the time it is implicit (like in the second example).

Cheers, Christiaan

As always, thank you! I really appreciate you explaining as well. That’ll help me long term.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.