Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Counting specific text values in a column

Hey all,

 

PBI noob back again.

 

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

CategoryType
petcat
petdog
pethorse
petcat
petcat
pethorse

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

 

Need Help
  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    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     🙂 

1 Reply

  • nandukrishnavs's avatar
    nandukrishnavs
    Community Champion
    6 years ago

    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     🙂