Counting Number of Items

[Chris_Thomas1]

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:

[Saul_Garcia]

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

CountUnique(thisRow.Points.Show)

As you had already filtered by member in the Points column

I hope it helps

[Chris_Thomas1]

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