Creating flags in dataset

[AMCM0806]

I have a sample dataset attached. 

I would like to create a new column in this dataset that will give me a "1" or "0" flag based on whether a position contains at least one "ready in emergency" candidates. 

The formula I'm using is creating the flag on the Candidate level, but I want the flag to reflect it on the position level. For example, as long as there is one "ready in emergency" candidate in a given position, then the flag will be 0. 

IF
(
[Role] = "Partner" OR
[Role] = "President"
)
AND
NOT Contains([Readiness], "Ready in Emergency")
THEN
1
ELSE
0
ENDIF

[Qiu · Accepted solution]

@AMCM0806 
We can filter out the Rows with Flag "0" after your formula then take unique entries on "Position" then join back to the data stream with key "Position".
I believe You data is missing the value for "Data" and "Position" for the last row.