Report a feature count based on a string value from distinct strings selected from features selected

I am looking creating a distinct feature count based on the values found in a workflow. I have a report that will compile all the unique species found. I have grouped them together so its not showing the duplicate values. However I would like to show a feature count from the species it found. I can find the total features and unique features. But I would like to see:

American Burying Beetle (1)

Finescale Dace (2)

Northern Redbelly Dace (1)

See attached pdf of what I can currently output. I tried IIF statements not they all show false values.

Iif([SCOMNAME] Like'Finescale Dace' , [DataSource.RowCount] ,False )

I have also tried the contain option.

The tech tip video shows only integer values no strings to help do the conditional statements.

Any ideas?

Thanks,

Claire