Evaluate values in column B, for each distinct value in column A and return result in column C

[cmck]

Hi, 

I am trying to make a new column for my dataset. Below is a basic representation of my data. 

In column C (ready to go home) I want to say that if all animals of the same type have been chipped then they are ready to go home. (i.e. for each distinct value in column A, I want to evaluate whether all values in column B = "Yes", if so return "Yes" in column C)

In this case, one dog has not been chipped and so dog is not ready to go home. All cats have been chipped and so can be moved home.

Animal	Chipped?	Ready to go home?
Dog	Yes	No
Dog	Yes	No
Dog	No	No
Cat	Yes	Yes
Cat	Yes	Yes

Thanks in advance

[Uspace87 · Accepted solution]

Ready go home = IF(COUNTROWS(FILTER('Table', 'Table'[Animal]= EARLIER('Table'[Animal]) && 'Table'[Chipped] = "Yes")) = COUNTROWS(FILTER('Table', 'Table'[Animal] = EARLIER('Table'[Animal]))), "Yes", "No")

[cmck]

Thank you!!!

If I make a new table with the distinct animals in, is there a way I can tidy up the results and just have a single line with yes/no for each animal?

Animal	Ready to go home
Dog	No
Cat	Yes

[Uspace87]

you can just plot it with animal and the ready to go home column