My calc to count the number of 'Apples' in my database is:
ValueCount ( FilterValues ( List (Fruit) ; "Apples" ) )
The context of your question is not quite clear:
will list the values in current record only. In any case, if you count ALL values and subtract the Apples, you'll get the number you seek.
ValueCount ( List ( Fruit ) ) - ValueCount ( FilterValues ( List ( Fruit ) ; "Apples" ) )
Edit: Hi Michael !
Dear comment & Daniele,
It works (unsurprisingly)!
Thanks very much once again for your assistance.
I'm still getting m head around valuecount syntax.