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?
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.