Counting specific text values in a column

[Anonymous]

Hey all,

PBI noob back again.

I have a data set that a column has about 5 different possible values. example

Category	Type
pet	cat
pet	dog
pet	horse
pet	cat
pet	cat
pet	horse

I need to count only 2 of the 3 values? (e.g I need to count the cat and dog entries but not the horse)

How do I do that??

Thanks

[nandukrishnavs · Accepted solution]

@Anonymous 

count_dog_cat = CALCULATE(COUNT(PetTable[Type]),PetTable[Type] IN {"cat","dog"})

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂