Forum Discussion

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

Not applicable

2 years ago

Hi Anonymous ,

Based on your problems, here are my answers.

I create a corresponding table based on your needs.

Then write the DAX code to get a new column, this column is used to indicate whether the item is complete or not, denoted by True/False.

Column =
VAR _aa = 'Table'[PackageID]
VAR _A =
    CALCULATETABLE ( 'Table', FILTER ( 'Table', 'Table'[PackageID] = _aa ) )
VAR _B =
    FILTER ( _A, 'Table'[IsComplete] = FALSE () )
RETURN
    IF ( COUNTROWS ( _B ) = 0, TRUE (), FALSE () )

Finally, you will get what you want.