Evaluate True False based on indentification code

[mvgust]

I'm trying to setup a true false evaluation statement similar to below. Ideally what I want is to only show the rows where the same code has a value in both the OT column and the PT column. I figure if I can get the evulation column correcty I can just filter out the data that doesn't meet the criteria.  The highlighted yellow is the data I want to keep.

Thank you!

[az38 · Accepted solution]

Hi @mvgust 

try

IF(
CALCULATE(COUNTROWS(Table), ALLEXCEPT(Table, Table[Code]), Table[Value OT] <> BLANK()) > 0 &&
CALCULATE(COUNTROWS(Table), ALLEXCEPT(Table, Table[Code]), Table[Value PT] <> BLANK()) > 0,
TRUE(),
FALSE()
)

[mvgust]

That worked perfectly!  Thank you!