Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Custom Column Showing When All Complete

My data set has packages that have components (there can be any number of components) where each component is a separate row.   I'm looking to make a custom column that identifies when all of the c...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    In the end, this is what worked:

     

    Ready for Comp =
    var result =CALCULATE(MIN('Table'[Component Complete]),ALLEXCEPT('Table','Table'[Package]))
    return
    IF(result="False","Not Ready","Ready")
Anonymous's avatar
Anonymous
Not applicable
2 years ago

In the end, this is what worked:

 

Ready for Comp =
var result =CALCULATE(MIN('Table'[Component Complete]),ALLEXCEPT('Table','Table'[Package]))
return
IF(result="False","Not Ready","Ready")