Forum Discussion

graceweii's avatar
graceweii
Frequent Visitor
4 years ago
Solved

Create conditional column based on Two tables

I have two tables: Tests and Results. In the data model, the two tables are connected by the key column and it is a one (Tests) to many (Results).  relationship.  Tests:  key  Lot code 1 xx...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    graceweii 

    is this what you want?

    Measure = if(COUNTROWS('Results')=CALCULATE(COUNTROWS(Results),FILTER(Results,Results[condition]="pass")),"pass","fail")

ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

graceweii 

is this what you want?

Measure = if(COUNTROWS('Results')=CALCULATE(COUNTROWS(Results),FILTER(Results,Results[condition]="pass")),"pass","fail")