What is the formula to filter out a a subfield (trout in Fish field) name in a table?

[amassman]

I am trying to filter on a subfield (trout) from a Fish field in a large table and the filter formula is not working for me.

Currently, I am using the below formula:

=FILTER('Fishing Stats',[Fish]="Trout")

Your help is much appreciated!

-Aaron

[mike_honey]

Are you using this in a Measure?  FILTER returns a table, where a Measure needs a number.  FILTER is most commonly used inside other functions e.g. SUMX ( FILTER ( ...