Filter table or Matrix

[SO]

Imagine the table below

Staff	Animal	House	Color
A	Dog	Big	Red
B	Cat	Small	Green
C	Mouse	Large	Blue
D	Cat	Big	Red
E	Camel	Small	Red
F	CatFish	Big	Red

Using a measure, I'm looking to filter the table so that I can find which staff that have Animals that start with "Cat*"

Staff	Animal	House	Color
B	Cat	Small	Green
D	Cat	Big	Red
F	CatFish	Big	Red
Total	3	3	3

Is this possibe?  I can get counts of Cat* and I can filter with the "Cat*", but I am stuck in producing a table with Counts. 

Thoughts?

[Greg_Deckler · Accepted solution]

This is pretty rough, but here is one way to do it. PBIX attached.

Measure = 
  IF(HASONEVALUE('Table'[Animal]),
    IF(SEARCH("Cat",MAX('Table'[Animal]),,0) > 0,1,0),
    SUMX(
        ADDCOLUMNS(
            'Table',
            "__Measure",IF(SEARCH("Cat",[Animal],,0) > 0,1,0)
        ),[__Measure]
    )
  )

[SO]

Wow!

I'm still tying to understand why and how this works, but it does!  

I have not used ADDCOLUMNS or HASONEVALUE so I have some research to do.

Many Thanks again