Creation of two tables

[PaulPalkowski]

From the data I want to create two tables

Both tables should show who fed any animal collectively other than the bear or camel more than 3 times
but one that the staff prepared the food at least once
and one that the staff never prepared the food...

I want to be able the get the percentage of day and night feeding which I should be able to do once I get these tables created

Any help on this?

Task ID	Staff Name	Animal	Time	Prepared Food
F0001	Steve	Bear	Day	No
F0002	Jeff	Horse	Night	Yes
F0003	Jerry	Lion	Day	No
F0004	Peter	Tiger	Night	No
F0005	Steve	Bear	Day	No
F0006	Jeff	Horse	Night	No
F0007	Jerry	Lion	Day	Yes
F0008	Peter	Tiger	Night	No
F0009	Steve	Bear	Day	No
F0010	Jeff	Horse	Night	No
F0011	Jerry	Lion	Day	No
F0012	Peter	Tiger	Night	No
F0013	Jeff	Bear	Day	Yes
F0014	Jerry	Horse	Night	No
F0015	Jeff	Lion	Day	Yes
F0016	Jerry	Tiger	Night	No
F0017	Steve	Bear	Day	No
F0018	Jeff	Horse	Night	No
F0019	Jerry	Lion	Day	No
F0020	Steve	Tiger	Night	No
F0021	Jeff	Bear	Day	No
F0022	Jerry	Bear	Night	No
F0023	Paul	Lion	Night	Yes
F0024	Paul	Camel	Day	No
F0025	Peter	Lion	Day	No
F0026	Peter	Camel	Day	No

[amitchandak]

@PaulPalkowski , Based on what is got, Try measures like

Day night ratio = divide(countrows(filter(table, Table[Time] ="Day")),countrows(filter(table, Table[Time] ="Night")))

Never prepared food = countx(filter(Tbale, Table[Staff Name], "_1",count(Table[Staff Name]), "_2",calculate(Table[Staff Name], filter(Table, Table[Prepared Food] ="No")), [_1]=[_2])[Staff name])

[PaulPalkowski · Accepted solution]

I am having problems with the table creation, the table name is Feeding, even making those edits, I still get errors in the DAX

Never prepared food = countx(filter(Feeding, Feeding[Staff Name], "_1",count(Feeding[Staff Name]), "_2",calculate(Feeding[Staff Name], filter(Feeding, Feeding[Prepared Food] ="No")), [_1]=[_2])[Staff name])

"The syntax for '[Staff name]' is incorrect. (DAX(countx(filter(Feeding, Feeding[Staff Name], "_1",count(Feeding[Staff Name]), "_2",calculate(Feeding[Staff Name], filter(Feeding, Feeding[Prepared Food] ="No")), [_1]=[_2])[Staff name])))."