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")
shravanreddy133's avatar
shravanreddy133
Helper I
2 years ago

Hi,

Go to the "Modeling" tab in Power BI.

  1. Click on "New Column" from the toolbar.

  2. In the formula bar that appears, enter the following DAX formula:

AllComponentsComplete =
CALCULATE(
AND(
COUNTROWS(FILTER('YourTable', 'YourTable'[PackageID] = EARLIER('YourTable'[PackageID]))),
COUNTROWS(FILTER('YourTable', 'YourTable'[PackageID] = EARLIER('YourTable'[PackageID]) && 'YourTable'[Complete] = TRUE))
),
ALLEXCEPT('YourTable', 'YourTable'[PackageID])
)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

I'm getting an error: