Counting Number of Items

I am creating a system to track our members scores in horse shows. I’ve managed to create all the tables I need and have the sorting and grouping down. The last item I need on a Detail screen is to count the number of unique “shows” a member has attended. Every formula I’ve tried either gives me the count of ALL the shows I have in the shows table or it gives me an error. Here is the details page Im trying to figure this out on:

Hello @Chris_Thomas1!
To show only the ones your member attended you have to filter the shows by member, as follows

Shows.Filter([Points Worksheet].Member.contains(thisRow)).Count()

Alternatively, you can just use


As you had already filtered by member in the Points column

I hope it helps :wink:

I KNEW it was something simple. Thank you so much for your help and time!

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