Forum Discussion

mvgust's avatar
mvgust
Helper III
6 years ago
Solved

Evaluate True False based on indentification code

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!

 

 

Need Help
  • az38's avatar
    az38
    6 years ago

    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()
)

2 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    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()
)